A possible workaround would be to right-click the hyperlink in IE and select
Save Target. Once the file has been saved to your local disk, open it
normally.
--
Gary''s Student - gsnu2007c


"Keith74" wrote:

Hi All

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.

Any Thoughts?

cheers

Keith

p.s. i'm using 2003