Hi!
I'm trying to write a script in W2k (.wsf) that automatically prints an Excel-file.
I have been able to open the file, set the default printer, print the file, and close it.
The problem is, that the Excel-file contains a link to data in an Access-database, and the data doesn't update when my script opens the file.
When I open the Excel-file the data updates just fine by itself, so it seems that the property "Autorefresh external data" won't work if the file is opened by a script.
Any clues to how to update the data from the script? Something like oXL.ActiveWorkBook.RefreshData ???
TIA
/Joakim
I'm trying to write a script in W2k (.wsf) that automatically prints an Excel-file.
I have been able to open the file, set the default printer, print the file, and close it.
The problem is, that the Excel-file contains a link to data in an Access-database, and the data doesn't update when my script opens the file.
When I open the Excel-file the data updates just fine by itself, so it seems that the property "Autorefresh external data" won't work if the file is opened by a script.
Any clues to how to update the data from the script? Something like oXL.ActiveWorkBook.RefreshData ???
TIA
/Joakim
