automatically refresh excel data on

February 2, 2006 at 08:31:15
Specs: XP Pro, 1.5ghz

Is it possible to open excel from a command line and to refresh the data as it does it?

Steve


See More: automatically refresh excel data on

Report •


#1
February 2, 2006 at 14:36:38

Of course it's possible to open Excel via a command line. As for refresh the data, you need to be much more specific. What type of data? Are the cells/sheets/workbook linked to others? Are you running any Macros when you open the workbook?

Soylent Green is PEOPLE!!!


Report •

#2
February 4, 2006 at 11:23:13

Hi, the spreadsheet gets it data via an odbc connection into an erp system, the file a customer file gets updated with new customers and when the spreadsheet is opened the users refresh the data but i would like the spreadsheet to do it automatically as it opens.

Regards

Steev


Report •

#3
February 6, 2006 at 07:26:37

You could create an autoexec macro that contains only the F9 function, which calculates the data.

Soylent Green is PEOPLE!!!


Report •

Related Solutions

#4
February 6, 2006 at 08:23:40

Its always best to keep it simple, many thanks - Recorded a macro called it Auto_Open and thats it.

Steve


Report •


Ask Question