badly struck! how to pass values from asp to excel

[VbUser25]

hi
i am opening an excel file in the same explorer window as the form. i am
storing values entered in excel in database. while saving the field in
the db i need to save a field from the form also.

how can i get a form value inside the vba code or to put it like this
how can i refer the form value inside excel???

i m simply opening a template of excel file.

pls suggest

 

[Guest]

Is this a UserForm in Excel? as opposed to a Form in say Access Database?

If it's an Excel Userform and you want the data transferred to a cell in
Excel then:
in the userform code module of the Visual Basic Editor you will have some
code that ends the userform, something like
Private Sub cmdOK_Click()
'some code
' Then add this line, adjusting the range as desired:
'This will transfer the data to your cell in a worksheet
Sheets("Sheet3").Range("B8")=Me.Textbox1.Value
'or if the data is in a combobox, use Me.ComboBox4.Value

Me.Hide
End sub

 

[VbUser25]

sorry i think i didnt write clearly..
i am creating a form in asp and need to pass just one value to the excel

 

[Bob Phillips]

Are you creating an instance of Excel within the ASP page, setting up an
Excel object, and then opening the form via that object. If so, you should
be able to get at the properties of the form okay.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[VbUser25]

no i am opening it thru a href... i want to open excel such that it
opens with the excel file menu. so this way it opens in the same Window
and with the explorer menu and not hte excel menu