Automation to Excel

B

Bob Barnes

What code would be used to do the following...

During transfer Of Access data to Excel via automation,
the Excel file is "Open".

I have code that "Errors" at error 70 (lets me know that Excel file
is "Open" for the automation transfer). I would like to "Close" that
Open file via code.

Any suggestions?

TIA - Bob
 
Top