Method 'Open' of object 'Workbooks' failed from within browser window

[ramiro]

hi all,

I've got an excel Macro in one of my projects that has to retrieve data from a seperate excel spreadsheet on the web. below is the code I use to extract that data:

Please Login or Register  to view this content.

This code works perfectly when it runs in Excel 2003, but when a link to the workbook was put on a webpage, it runs from within an Internet Explorer browser window, and this macro dies with error message "Method 'Open' of object 'Workbooks' failed".

Is this a shortcoming of running Excel from within a browser window? Is there a workaround for this?

thanks for any help you can give

[ramiro]

I've made the error message display a more useful message to the user, informing them that they should download the form instead of opening it in internet explorer, but this is really just a temporary solution.

Is there no way of copying a worksheet from a location on the web from an excel workbook opened in Internet Explorer?