automation on excel(automated from Access VBA code) stops when opening another excel file

T

thread

Hi all,
I built automation in vba to automate excel from access
my problem is when another excel file is opened,the automation on the
excel file stops
is it posible to block any interrupt of another excel file during the
automation?
 
A

Aaron Kempf

yeah.

Dim XlApp as new Excel.Application
XlApp.Visible = False

now.. if you're running macros in another workbook; and you don't properly
look for the current workbook?

then you need to fix your code
 

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

conflict in automation when trying to open another excel file 3
Automation to Excel - Setting "Interior.ColorIndex" 1
Excel not "letting go" after DoCmd.Transferspreadsheet (Automation) 3
opening/extracting ole object file from table to a file via VBA 1
Automation to Excel leaves Excel open until Access closed 4
Access automation leaves Excel open which in turn locks 2nd automation attempts 8
export formating together with the data 2
Importing Excel file without server access 3

Top