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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Automation of scanned file storage based on content 0
Excel - Wich Function should I use? 1
You'll need a new app to open this about link 1
Visio to Excel 0
Word 2013 DDE merge to Excel file 0
Integrating information from Word to Excel (not mail merge) 1
Embed the same Excel multiple times 0

Top