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