| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate update of worksheet
I get data into a sql server database from Worksheet1.xls that has links to other spread sheets. To have the latest data in worksheet1.xls, I have to open it and select yes to "Enable Macros".
I would like to automate the update of a worksheet without having to open worksheet1.xls file. If that is do-able than I could schedule the script to get data into sql server without having to open the .xls file. Thanks in advance for the hel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate Insert Worksheet & Name | Excel Discussion (Misc queries) | |||
| automate date entry - update pls. | Excel Worksheet Functions | |||
| How can I automate the saving of a worksheet? | Excel Discussion (Misc queries) | |||
| Automate worksheet copy | Excel Discussion (Misc queries) | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
