dhtml and spreadsheet web component

P

Paul Ghattas

I am sorry if this is stupid but I am very new at this. I would like to
export an excel doc that I have in a dhtml proj and I am using the following
code with a DHTML file and office web component control of excel

Private Function SubmitButton1_onclick() As Boolean
Spreadsheet1.Export ("C:\Documents and Settings\paulg\Desktop\Copy of ravens
03.xml",ocw10.ssExportActionNone)
End Function

I get an error saying expected expression =

if I take out the ocw10.ssexportactionone then it works fine except it tries
to open the file after it has been exported and I want it to do nothing
after it exports. Can someone tell me what I did wrong? I would greatly
appreciate it.

Thank you in advance

Again I apologize if this stupid or not dueable.
 
D

Dan Ricker

instead of
OWC10.ssExportActionNone
use
SpreadSheet1.Constants.ssExportActionNone

To allow Web pages to access the constants defined in the
DLL, OWC uses a "Constants" "object" with each constant
being a property of that "Constants" object.


-----Original Message-----
I am sorry if this is stupid but I am very new at this. I would like to
export an excel doc that I have in a dhtml proj and I am using the following
code with a DHTML file and office web component control of excel

Private Function SubmitButton1_onclick() As Boolean
Spreadsheet1.Export ("C:\Documents and
Settings\paulg\Desktop\Copy of ravens
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top