Hi,
I regularly drive reports from access using both Word and Excel as servers. I open the excel object, write data to the excel worksheet where a preformatted graph exists, and excel refreshes the graph when the data are written to it.
If I set up a loop to work through repetitive graphs, Access spits the dummy. An examination of the task manager shows that there are multiple excel sessions open.
The syntax used to close down Excel does not work (eg Set wbl = Nothing; Set shl = Nothing; app.Quit; wbl.Quit and any combinations thereof!) The only way to get it to work is close access then reopen it.
With Word the process works perfectly, using the same object structure and close off procedure.
Is this a bug with Access/Excel that does not exist with Access/Word?
I regularly drive reports from access using both Word and Excel as servers. I open the excel object, write data to the excel worksheet where a preformatted graph exists, and excel refreshes the graph when the data are written to it.
If I set up a loop to work through repetitive graphs, Access spits the dummy. An examination of the task manager shows that there are multiple excel sessions open.
The syntax used to close down Excel does not work (eg Set wbl = Nothing; Set shl = Nothing; app.Quit; wbl.Quit and any combinations thereof!) The only way to get it to work is close access then reopen it.
With Word the process works perfectly, using the same object structure and close off procedure.
Is this a bug with Access/Excel that does not exist with Access/Word?