VBScript Export from OWC11 to Excel as XLS file

[BarryMVS]

Hi,

Can anyone offer me assitance in setting up the Export command for OWC11.

I have produced my XML page using ASP and have got down to my export command, but the script refuses to aknowledge my constants variable even though I have already defined it.

Dim oSS
Dim c

Set oSS = Server.CreateObject("OWC11.Spreadsheet")
    Set c = oSS.Constants

and

oSS.Export "test.xls", c.ssExportActionOpenInExcel, c.ssExportAsAppropriate

It keeps telling me that the object 'o' is missing.
If I add 'oSS.' in front of each of the constants for the Export command, the error is returned that 'c' is not an accepted methord or object.

I'm confused. Any assistance would be most welcomed thanks,


Barry

ICT Network Administrator
IT Services Manager