C
Carmen
I've got an Excel workbook that contains several macros
that do the following: pull data from an SQL datasource,
plot several charts and then publish to the web (intranet).
All the above is done using VBA and the data pulling,
charting and publishing subroutines are called by the
Workbook Open event.
I need to be able to have all of the above happen
automatically - say once an hour without a person opening
the Excel file.
I tried setting up a scheduled task to do this. It seems
that there are timing issues when the file is opened from
by the task scheduler.
I get a Runtime error: 1004 "This operation cannot be done
because the data is refreshing in the background."
Anyone, any ideas or suggestions about how to best
accomplish this task?
that do the following: pull data from an SQL datasource,
plot several charts and then publish to the web (intranet).
All the above is done using VBA and the data pulling,
charting and publishing subroutines are called by the
Workbook Open event.
I need to be able to have all of the above happen
automatically - say once an hour without a person opening
the Excel file.
I tried setting up a scheduled task to do this. It seems
that there are timing issues when the file is opened from
by the task scheduler.
I get a Runtime error: 1004 "This operation cannot be done
because the data is refreshing in the background."
Anyone, any ideas or suggestions about how to best
accomplish this task?