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

2
Contributors
2
Replies
6
Views
6 Years
Discussion Span
Last Post by Mounika_6
0

Is there any another solution for this error "Unable to get the Open property of the Workbooks class"

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.