Share via

Microsoft Excel: Open method workbook class failed

Anonymous
2011-10-26T19:30:57+00:00

Try to open several .xls format fies from Vbscript. under windows xp, office2010 and WSH version 5.7.

Get "Microsoft Excel: Open Method of Workbook class failed"

My coding is as following:

Set XL = CreateObject("Excel.Application")

XL.Visible=True

XL.Workbooks.Open "C:\Documents and Settings\Zhen.Qin\Desktop\Oct22_2011\ELC_Churn_by_Tenure.xls"

XL.Workbooks.Open "C:\Documents and Settings\Zhen.Qin\Desktop\Oct22_2011\tv_pivot_1.xls"

thanks for any and all help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-10-31T03:06:10+00:00

    Hi,

    Please check whether these files can be manually opened correctly.

    Was this answer helpful?

    0 comments