Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
badly struck! how to pass values from asp to excel
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
badly struck! how to pass values from asp to excel
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" wrote: 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
badly struck! how to pass values from asp to excel
sorry i think i didnt write clearly.. i am creating a form in asp and need to pass just one value to the excel *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
badly struck! how to pass values from asp to excel
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" wrote in message ... sorry i think i didnt write clearly.. i am creating a form in asp and need to pass just one value to the excel *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
badly struck! how to pass values from asp to excel
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help in EXCEL functions - needed badly | New Users to Excel | |||
i have an excel file which i badly need for my project. the probl | Excel Discussion (Misc queries) | |||
How to pass values of a cell? | Excel Discussion (Misc queries) | |||
How to pass values from a userform to a standard module? | Excel Programming | |||
can variables pass values | Excel Programming |