Fabulous and simple solution to get it done! THANK YOU SO MUCH!!! You really should have a Donate button here since this saved me HOURS I'd love to "pay it forward".
this video is so helpful, thank you for this. However I have one question. Suppose I am doing work in another excel file, and the automation executes, it will close my workbook as well for the Application.Quit command mentioned in 19:09 , will anything happen if i do not close the application? There might also be times when i am not working the code executes, i do not mind a blank excel window being open.
You're welcome. I'm glad I could assist you. Regarding your query, it's generally recommended to close unnecessary Excel applications when executing a series of macros. This allows the computer to allocate resources more efficiently to the active window. If multiple Excel instances remain open and your macro doesn't explicitly specify navigation, there's a risk of unintended interactions or errors during execution.
Excelletn video. Thanks for sharing. I have a question. The automation by task scheduler is achieved by setting the VBA run when open the excel file. Could you please show how to use task scheduler to run a macro rather than set the macro run when opening a file? Thanks
Yes, we can do that by saving the macro as VBScript (.vbs) file. In this technique you'll have to call the Excel application within the .vbs file and the rest will be taken care of by the code.
You may choose Excel to not show what is being executed, but it will still open an instance in the background. You can check Task Manager when your macros execute.
Fabulous and simple solution to get it done! THANK YOU SO MUCH!!! You really should have a Donate button here since this saved me HOURS I'd love to "pay it forward".
Glad it helped!
Best video about macroo thanks
Glad it helped
true that
Very well explained :)
Glad you liked it
this video is so helpful, thank you for this. However I have one question. Suppose I am doing work in another excel file, and the automation executes, it will close my workbook as well for the
Application.Quit command mentioned in 19:09 , will anything happen if i do not close the application? There might also be times when i am not working the code executes, i do not mind a blank excel window being open.
You're welcome. I'm glad I could assist you. Regarding your query, it's generally recommended to close unnecessary Excel applications when executing a series of macros. This allows the computer to allocate resources more efficiently to the active window. If multiple Excel instances remain open and your macro doesn't explicitly specify navigation, there's a risk of unintended interactions or errors during execution.
Excelletn video. Thanks for sharing. I have a question. The automation by task scheduler is achieved by setting the VBA run when open the excel file. Could you please show how to use task scheduler to run a macro rather than set the macro run when opening a file? Thanks
Yes, we can do that by saving the macro as VBScript (.vbs) file. In this technique you'll have to call the Excel application within the .vbs file and the rest will be taken care of by the code.
@@SwachalanKaar Thanks
Great video.
I have 50+ files that need to be refreshed, is there a way I can loop it to refresh the files one at a time??
Yes you can!
Dear Sir
Pl guide if and how is it possible to refresh the files without opening them with the help of VBA preferably?
You may choose Excel to not show what is being executed, but it will still open an instance in the background. You can check Task Manager when your macros execute.
@@SwachalanKaar
Thanks for the guidance....
can it refresh excel inside the sharepoint instead of desktop?
Use Office Scripts instead of VBA for your use case.
any other updated way??
Depends on what you are trying to achieve. If you are using Excel Online then go for Office Scripts.