Access waits for Excell

[e.badin]

Hi guys,


I have an mdb report that opens an XLS file. The XLS has an query table that updates on opening with data from the mdb file, table X.
Now I want to change the data in table X and everytime, open the xls, print the contents and close. I have made the code for the XLS file so that on opening it prints and closes. My problem is that I want Access to wait until the file is closed and then generate new data in table X and so on...

For opening the excel I used

Call Shell(stAppName, vbMinimizedNoFocus)

If you're asking why the hell I'm doing this, well , it's some sort of pagebreaking on a report. Making it separate worksheets won't work as I may have to many sheets for excel to handle.

I'm opened to suggestions...

[RuralGuy]

This link should help: http://www.mvps.org/access/api/api0004.htm

[e.badin]

This link should help: http://www.mvps.org/access/api/api0004.htm

Thanks, you don't know how much I searched for something like that. So I use the new shellwait sub instead of the default shell one. Just making sure .

[RuralGuy]

Correct-a-mundo! Have fun.