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