I have just started getting this error as of 2/6/17 our database has been functioning since 1/26/15.
I am now running MS Office v2016 after upgrading July 28, 2015.
Microsoft VB
Run-time error '-2147023170 (800706be)':
Automoation Error
The remote procedure call failed.
Here is my code:
Function OpenExcelA3CustShipFromAccess()
' Opens an Excel file and runs a macro to update the data for the template
Dim MyXL As Object
Set MyXL = CreateObject("Excel.Application")
With MyXL
.Application.Visible = True
.Workbooks.Open "C:\DBWT\A3CustShip.xlsm"
.Run "GetData"
End With
End Function
When I click on Debug the .Run "GetData" is highlighted in yellow.
I just started learning VB in 2014 by googling for examples of what I wanted to do, so I am aware my code might not optimal.
Thank you! Robecca
I am now running MS Office v2016 after upgrading July 28, 2015.
Microsoft VB
Run-time error '-2147023170 (800706be)':
Automoation Error
The remote procedure call failed.
Here is my code:
Function OpenExcelA3CustShipFromAccess()
' Opens an Excel file and runs a macro to update the data for the template
Dim MyXL As Object
Set MyXL = CreateObject("Excel.Application")
With MyXL
.Application.Visible = True
.Workbooks.Open "C:\DBWT\A3CustShip.xlsm"
.Run "GetData"
End With
End Function
When I click on Debug the .Run "GetData" is highlighted in yellow.
I just started learning VB in 2014 by googling for examples of what I wanted to do, so I am aware my code might not optimal.
Thank you! Robecca