File system object

[madhuri.t]

Hi Guys,
I am trying to open an excel sheet on an ASP page using the using the following code given below. but it looks like on some machines the File System object is getting created and on some machines not. On some systems the excel sheet opens and on other it doesn't open, instead it throws a http 500 error. Can you please tell me why this is happening.
Regards,
Madhuri

[Rob]

Why not use the ODBC driver for excel files??

Code: Select all

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
           "DriverId=790;" & _
           "Dbq=c:\somepath\mySpreadsheet.xls;" & _
           "DefaultDir=c:\somepath"