Is it possible to open excel from a command line and to refresh the data as it does it? Steve
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!!!
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
You could create an autoexec macro that contains only the F9 function, which calculates the data. Soylent Green is PEOPLE!!!
Its always best to keep it simple, many thanks - Recorded a macro called it Auto_Open and thats it. Steve
