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

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

Dear Keith,

This is a local client option in Excel to open via XL or IE
--
Regards

Jean-Yves Tfelt
Europe


"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

Hi Jean-Yves Tfelt

Could you tell me where this option is?

Thanks

Keith

Was not a XL option but window

See http://support.microsoft.com/?kbid=162059 (Mar. 17, 2002)
Extract
To configure Internet Explorer to open Office files in the appropriate
Office program by using the Folder Options tool: 1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click the specific Office document
type (for example, Microsoft Excel Worksheet), and then click Advanced (or
click Edit).
5. In the Edit File Type dialog box, click to clear the Browse in same
window check box (or click to clear the Open Web documents in place check
box).
6. Click OK.

--
Regards

Jean-Yves Tfelt
Europe


"Keith74" wrote:

Hi Jean-Yves Tfelt

Could you tell me where this option is?

Thanks

Keith

Thanks