Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Updates
Not exactly an excel question but thought you maybe able to help.
I currently have an excel speadsheet that has a link to SQL server. I am the only person that has access to SQL. SQL updates the tables at 1 am everyday. To update the spreadsheet I have to open the file, refresh and then save for other people to be able to see the changes. What I am wanting to do is to set some sort of task that will automatically open the spreadsheet at 2am, refresh it and save it. The reason I am wanting to do this is so that when I am holiday the spreadsheet is always upto date. (Plus it saves me doing it) Is this possible?? The Rook |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Updates
You can schedule a windows task to open a workbook. When the workbook opens,
you can insert code to auto refresh and save. An easier approach is to always have a master workbook open and at specified times (using a "wait" or similar function), have the workbook update and save a copy of itself. Either works, but it is easier to code the latter and I have found it is more reliable. Regards, Bill Pfister "TheRook" wrote: Not exactly an excel question but thought you maybe able to help. I currently have an excel speadsheet that has a link to SQL server. I am the only person that has access to SQL. SQL updates the tables at 1 am everyday. To update the spreadsheet I have to open the file, refresh and then save for other people to be able to see the changes. What I am wanting to do is to set some sort of task that will automatically open the spreadsheet at 2am, refresh it and save it. The reason I am wanting to do this is so that when I am holiday the spreadsheet is always upto date. (Plus it saves me doing it) Is this possible?? The Rook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Updates | Excel Discussion (Misc queries) | |||
Automatic updates | Excel Discussion (Misc queries) | |||
Automatic Array updates | Excel Discussion (Misc queries) | |||
Sharing - Automatic Updates | Excel Discussion (Misc queries) | |||
AUTOMATIC UPDATES | Excel Worksheet Functions |