Need to auto update excel file on server 1

[gizzy17]

Is there a way that I could write a windows script that would run on a server to open an excel spreadsheet and run an update macro inside of it then save the spreadsheet again? The excel file will be stored on a server with read only attributes and needs to be updated automaticaly each night.

 

[tbl]

You could use an ONTime macro within Excel that would automatically update Excel from within Excel.

Richard

 

[gizzy17]

Wouldn't an ONTime macro require the excel file to remain open under a user acount on the server?

 

[tbl]

OnTime will run a macro of your choice in any open Excel book. You could leave Excel running (and then no-one could access it by accident :->

Richard

 

[Mikeb1970]

Hi gizzy,

You also could consider using another program, an automating program like the one offered by

http://www.unisyn.com/

I use it to retrieve stock quotes, and when i have all the quotes needed it starts excel, which analyses all data.
After the data analyses excel shuts down, and the timer will trigger a new start when needed.

With regards

Mike

 

[gizzy17]

Thanks Mike,

Automation software is probably what we will eventualy have to use.

Gizzy