Open method of Workbooks failed when Excel is hosted in IE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samuel_d_jack@alias.com - 26 Jan 2004 15:11 GMT

I have an Excel macro in an xla addin that calls the Workbooks.Open method. The piece of code works fine if I just execute it from Excel normally

However, if I call the macro via an instance of Excel that is hosted in Internet Explorer (in .Net as it happens) the Workbooks.Open method fails with the error "Method 'Open' of 'Workbooks' failed".

I'm using Office XP on Windows XP Pro

I've discovered loads of people in the newsgroups who have had this problem, but I haven't see any answers. Surely their must be one?

Reply to this Message

Wei-Dong Xu [MSFT] - 28 Jan 2004 04:07 GMT

Hi samuel,

Thanks for participating the community!

I have replied you at the same thread in the queue
Microsoft.public.excel.programming.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services

Signature

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...