Member Avatar for PotaZinga

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
  • 4K Views
  • 6 Years Discussion Span
  • Latest Post Latest Post by Mounika_6
Member Avatar for Mounika_6

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.