psionpete
July 30th, 2003, 11:30 AM
Can anyone please help?
I am trying to launch MSExcel from clientside vbscript in a .asp file (the problem also exists in a vanilla .html file).
I am using
set app = createobject("Excel.Application") etc.
to launch Excel. The .xls file is on a remote server and contains VBAcode for processing the worksheets.
This works OK so long as Excel2000 is used. If the client has Excel97 installed, then the worksheet code gives run time errors despite the fact that I can run the worksheet directly under Win NT/Excel 97 (without launching from a .asp file).
The code causing the run time error is nothing special, I am simply updating a cell on the worksheet using Worksheets.cells(x,y).value= x
Thanks in anticipation
PS the .asp file is on a company Intranet and the excel spreadsheet is accessed via a mapped drive to a server on the company network.
I am trying to launch MSExcel from clientside vbscript in a .asp file (the problem also exists in a vanilla .html file).
I am using
set app = createobject("Excel.Application") etc.
to launch Excel. The .xls file is on a remote server and contains VBAcode for processing the worksheets.
This works OK so long as Excel2000 is used. If the client has Excel97 installed, then the worksheet code gives run time errors despite the fact that I can run the worksheet directly under Win NT/Excel 97 (without launching from a .asp file).
The code causing the run time error is nothing special, I am simply updating a cell on the worksheet using Worksheets.cells(x,y).value= x
Thanks in anticipation
PS the .asp file is on a company Intranet and the excel spreadsheet is accessed via a mapped drive to a server on the company network.