open excel and run macro on button click

Discussion in 'ASP General' started by VbUser25, Jan 27, 2005.

  1. VbUser25

    VbUser25 Guest

    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!
     
    VbUser25, Jan 27, 2005
    #1
    1. Advertising

  2. VbUser25

    BenM Guest

    It has been a while since I have been concerned with VBA, but couldn't you
    set a macro to simply run when the file loads? This would be similar to the
    onload event, etc....
     
    BenM, Jan 27, 2005
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Purvi T
    Replies:
    0
    Views:
    904
    Purvi T
    Oct 19, 2004
  2. mike parr
    Replies:
    1
    Views:
    516
    Marina
    May 20, 2004
  3. Ben Fidge
    Replies:
    5
    Views:
    754
    S. Justin Gengo
    Jun 15, 2004
  4. Darshit Rao

    Run Excel Macro from Java

    Darshit Rao, Jan 20, 2005, in forum: Java
    Replies:
    2
    Views:
    13,055
    Heiner K├╝cker
    Jan 20, 2005
  5. Amy
    Replies:
    0
    Views:
    1,017
Loading...

Share This Page