0

Hi everyone i am getting an error that says Microsoft Office Excel error '800a03ec'
Unable to get the Open property of the Workbooks class when i try to open an excel work book in my code . The line of code where i get the error is Set ExcelBook = ExcelApp.Workbooks.open(BookPath) where BookPath is the path to the file .
The code before the line where the error is looks like this

Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = false 
BookPath = "c:\filename.xls"  
Set ExcelBook = ExcelApp.Workbooks.open(BookPath)

please help and thank you in advance

1
Contributor
1
Reply
3
Views
5 Years
Discussion Span
Last Post by PotaZinga
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.