conflict in automation when trying to open another excel file

T

thread

Hi all,
I build automation that is working from access on an excel
file(object).when i'm trying to open another excel file,the automation
is stoping and i'm getting an error.
is it posible to isolate the automation so it will not be disturbed
when other excel file is been open?
 
D

Daniel

No one can answer a question about your code if you do not provide it for us
to review. Please post the code that is problematic so we can identify the
underlying issue.
 
T

thread

all what i'm doing is buiding an object in vba and this way i'm making
automated command on the excel file
i believe its easy to identify what i did as it is something very
common
Set xlApp = CreateObject("Excel.Application")
thefile = xlApp.Application.GetOpenFilename("xls files (*.xls),
*.xls", , "Insite survey-Pick a file", "OK")
Set xlWB = xlApp.Workbooks.Open(thefile) ' create a new workbook
sPath = xlApp.Application.ActiveWorkbook.Path
Daniel כתב:
 
T

thread

the rest is of course autmation of excel.
using this object i'm automating the excel
thread כתב:
 

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
sqlite-odbc write conflict 2
Default local file location - folder redirection slowness 0
Uncompiled Form/Report Module after LoadFromText 0
Embed the same Excel multiple times 0
automation on excel(automated from Access VBA code) stops when opening another excel file 1
Merging from an Excel file with graphics 1
opening/extracting ole object file from table to a file via VBA 1

Top