conflict in automation when trying to open another excel file

  • Thread starter Thread starter thread
  • Start date Start date
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?
 
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.
 
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 כתב:
 
the rest is of course autmation of excel.
using this object i'm automating the excel
thread כתב:
 
Back
Top