Jan 8 2008, 07:15 AM
I've a workbook that is being opened via a hyperlink in IE. So that the workbook effectively opens up within IE. The problem i'm having is that the Workbook.open method is no longer working, returns a 1004 error, but works fine if you open it up in excel.
Jan 8 2008, 10:09 AM
why do you need to use that in an IE environment. I think IE can only handle one excel document at a time and won't allow you to automate it in the fashion you might be used to from directly within Excel. So if you can avoid it that I would work with this within Excel at the client.
Jan 8 2008, 10:57 AM
Jan 8 2008, 11:12 AM
Glad you found a workaround.
Good luck on future projects!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here