Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a macro from asp??
hi.. i have a form i accept some user inputs in the form. there is a link on the form from where i open the excel file in the same browser (not in a new page...simply using a href. i am also accepting input from the user in the excel. now i want to save the data in excel as well as on asp form. i can save directly thru vba code in excel to the db. but suppose the user comes back to the form and somehow doesnt click the submit button of the asp form to save the data. then it would mean that i saved a certain piece of data in the db thru excel and the other relevant data didnt get saved at all! so i revised my approach. now what i want is that when i click the submit button on the form i want to save the excel data also. for this what i am doing is...when i open the excel template i let user enter data inside it and then i will let him a copy of the excel file on his machine(cleint machine). so in the end when the user clicks the submit button i will 1. save the form data in database 2. open the excel file stored in clients machine 3. run a procedure inside it whihc save the data in the db can i open the excel file on button click on asp form and then run a macro in the excel file? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a macro from asp??
any microsoft expert can suggest something on this... i need help on it now *** 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 | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |