asked on Opening a Workbook from Access 2016
Hi,
My client is upgrading from Office 2010 to Office 2016 so I need to get the following code to work but I don't understand why the following won't work.
I am getting the following error unless I set Excel to be visible:
Runtime Error -2147417851 (80010105)
Method 'Open' of object 'Workbooks' failed
dim objXL as Object
Dim objWkb As Object
Set objXL = New Excel.Application
stDealerAC = "ABBEYNW"
'objXL.Visible = True
Set objWkb = objXL.Workbooks.Open("H:\o
Question: How can I get it to run without objXL.Visible = True?
My client is upgrading from Office 2010 to Office 2016 so I need to get the following code to work but I don't understand why the following won't work.
I am getting the following error unless I set Excel to be visible:
Runtime Error -2147417851 (80010105)
Method 'Open' of object 'Workbooks' failed
dim objXL as Object
Dim objWkb As Object
Set objXL = New Excel.Application
stDealerAC = "ABBEYNW"
'objXL.Visible = True
Set objWkb = objXL.Workbooks.Open("H:\o
Question: How can I get it to run without objXL.Visible = True?
VBAMicrosoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Crystal
you're welcome ~ happy to help