I have an excel file that gets daily data from a website and I defined a macro for sending the new data to the database, my question is how can I do this without needing someone to run the script? something like store an excel file in a web server ?!
Asked
Active
Viewed 30 times
1 Answers
1
An Excel file on its own does nothing. It needs the Excel application installed to be of any use.
If you have access to a computer or server that has excel and is on all the time, you could create a scheduled task to run your macro at pre-defined times.
Using something like Way to run Excel macros from command line or batch file? to launch and run your macro.
NickSlash
- 4,758
- 3
- 21
- 38