Creating and opening Excel Document in ASP

[ISPrincess]

With out alot of the dims, following is a "representation" of my code in asp page. The problem is "Showing" the spreadsheet. In other words - the .visible = true does not cut it.

Does anyone know what will then bring up excel and display this sheet to user?

Dim oXLApp
Dim oXLWkb
Dim oXLWks
Dim oXLRng

Set oXLApp = createobject("Excel.Application&quot
Set oXLWkb = oXLApp.Workbooks.Add
Set oXLWks = oXLWkb.Worksheets.Add

oxlwks.Cells(1, 1).Value = "Some String"
'Select first row of sheet before opening
oXLWks.Cells(1, 1).Select

'Show the worksheet
oXLApp.Visible = True

'Release the objects
Set oXLApp = Nothing
Set oXLWkb = Nothing
Set oXLWks = Nothing

 

[ziyun]

hi,
u can try going to this website:

http://www.codeave.com/asp/code.asp?u_log=143

it will displays excel in the client browser

 

[ISPrincess]

Thank you Ziyun -

I will keep that site in my favorites!

But I guess I oversimplyfied.

I need to do ALOT of excel formatting also, (borders, colors, sums, etc), plus I would like to open and show the excel spreadsheet WITHOUT Saving it.

One more thing I would like to do in this dream is to have it open the CLIENT's copy of Excel.

Am I dreaming ? This has GOT to be possible.