Forum Discussion
How to automate a login and refresh of a spreadsheet via an Excel plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the foll...
NikolinoDE thank you for your response. It is greatly appreciated. I will try to implement what you've suggested and see where that gets me.
I did follow a similar process between posting my question and your response. This involved recording a macro, then a .bas file, then a .bat file then Windows Scheduler. This was yesterday. I'm not about to view the results. I assume there is log that tells me if the process was a success (the to check the actual contents).