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
 
Top