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

Automation of scanned file storage based on content 0
Autonumber field in Excel that behaves the same as Access 0
VBA to extract data 0
Automation to Excel - Setting "Interior.ColorIndex" 1
Default local file location - folder redirection slowness 0
conflict in automation when trying to open another excel file 3
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
Importing Excel file without server access 3

Top