P
Peter Heathcote
I have an excel 2000 worksheet with extensive VBA code. I
can open the worksheet in Excel 2000 and Excel 97 without
any problems (the code was written in Excel 2000 VBA but
works in both versions of Excel). The worksheet is located
on a server on a LAN.
However, when I try calling it from a web page, it seems to
give varying results. I have tried several methods of
calling the worksheet.
a) Using ASP and CreateObject("Excel.Application") and then
using this objects Open method to open the required
workbook. This works OK if Excel 2000 installed on client
but gives run time errors on clients with 97 installed.
b) Using a simle HTML HREF call. This does not give any
run time messages but neither does the code do what it
normally does when run directly under the installed Excel
application.
I have to say that I do have another worksheet also with
extensive code, which does work when called from web page.
However, the run time errors, when they do appear, are in
areas of code which should be perfectly OK.
Has anyone any suggestions on what may be going wrong or
some other way of opening the worksheet.
Thanks in advance
Peter
can open the worksheet in Excel 2000 and Excel 97 without
any problems (the code was written in Excel 2000 VBA but
works in both versions of Excel). The worksheet is located
on a server on a LAN.
However, when I try calling it from a web page, it seems to
give varying results. I have tried several methods of
calling the worksheet.
a) Using ASP and CreateObject("Excel.Application") and then
using this objects Open method to open the required
workbook. This works OK if Excel 2000 installed on client
but gives run time errors on clients with 97 installed.
b) Using a simle HTML HREF call. This does not give any
run time messages but neither does the code do what it
normally does when run directly under the installed Excel
application.
I have to say that I do have another worksheet also with
extensive code, which does work when called from web page.
However, the run time errors, when they do appear, are in
areas of code which should be perfectly OK.
Has anyone any suggestions on what may be going wrong or
some other way of opening the worksheet.
Thanks in advance
Peter