Open an excel-file from the web
 

I have an excel-file (Excel 2000) that works perfectly when I open it up from
my desktop and other company servers. But, when I have it on a WEB server and
have to open it with a http:-address, I get the Run-time error "9" "Subscript
out of range" and the Debug takes me to "Sheets("Import").Select"" or
Run-Time error 1004 "Method 'Sheets' of object '_Global' failed. I do open
them in new windows. Do I need a reference library and if so which one?

Open an excel-file from the web
 

This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened in a
browser.

Gunilla G wrote:

I have an excel-file (Excel 2000) that works perfectly when I open it up from
my desktop and other company servers. But, when I have it on a WEB server and
have to open it with a http:-address, I get the Run-time error "9" "Subscript
out of range" and the Debug takes me to "Sheets("Import").Select"" or
Run-Time error 1004 "Method 'Sheets' of object '_Global' failed. I do open
them in new windows. Do I need a reference library and if so which one?

--

Dave Peterson

Open an excel-file from the web
 

Unfortunately to configure Internet Explorer will only help me, not the ones
that are opening the Excel-file from their browser unless there is a way for
me to make that change eg by a code either in the htm/asp file or Excel-file.

"Dave Peterson" wrote:

This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened in a
browser.

Gunilla G wrote:

I have an excel-file (Excel 2000) that works perfectly when I open it up from
my desktop and other company servers. But, when I have it on a WEB server and
have to open it with a http:-address, I get the Run-time error "9" "Subscript
out of range" and the Debug takes me to "Sheets("Import").Select"" or
Run-Time error 1004 "Method 'Sheets' of object '_Global' failed. I do open
them in new windows. Do I need a reference library and if so which one?

--

Dave Peterson

Open an excel-file from the web
 

I don't speak htm/asp. You may want to ask in a forum dedicated to those if you
don't get a helpful response here.



Gunilla G wrote:

Unfortunately to configure Internet Explorer will only help me, not the ones
that are opening the Excel-file from their browser unless there is a way for
me to make that change eg by a code either in the htm/asp file or Excel-file.

"Dave Peterson" wrote:

This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened in a
browser.

Gunilla G wrote:

I have an excel-file (Excel 2000) that works perfectly when I open it up from
my desktop and other company servers. But, when I have it on a WEB server and
have to open it with a http:-address, I get the Run-time error "9" "Subscript
out of range" and the Debug takes me to "Sheets("Import").Select"" or
Run-Time error 1004 "Method 'Sheets' of object '_Global' failed. I do open
them in new windows. Do I need a reference library and if so which one?

--

Dave Peterson


--

Dave Peterson