Consulting

Results 1 to 2 of 2

Thread: Fill web form from Excel

  1. #1

    Fill web form from Excel

    I am a new user to Excel, and new to macros so bear with me.

    I am working on a project to transfer all the data from a spreadsheet and
    enter it into an online form. I have Usernames and Passwords (D8:E656) in the spreadsheet to fill it in on the website. I am trying to write a macro to do this for me.

    Here is step by step info.
    1) Copy the Username and Password (D8:E8) from spreadsheet.
    2) Open the website (I do apologize.. I can't post the link for the security purpose. but i have attached html webpage alongwith this post. So please check it.) using mozilla firefox and enter the webaddress. (Wait till it is fully opens)
    3) Paste the Username and Password on the webform & click on "Go" to submit.
    4) Click on "Inbox","Order" & "Logout" respectively.

    Repeat the same procedure with all the Usernames & Passwords

    Sorry if this question seems idiotic but I'm lost.
    Attached Files Attached Files

  2. #2
    Still no reply. Please tell me if any further information is needed.

    Quote Originally Posted by black_smith
    I am a new user to Excel, and new to macros so bear with me.

    I am working on a project to transfer all the data from a spreadsheet and
    enter it into an online form. I have Usernames and Passwords (D8:E656) in the spreadsheet to fill it in on the website. I am trying to write a macro to do this for me.

    Here is step by step info.
    1) Copy the Username and Password (D8:E8) from spreadsheet.
    2) Open the website (I do apologize.. I can't post the link for the security purpose. but i have attached html webpage alongwith this post. So please check it.) using mozilla firefox and enter the webaddress. (Wait till it is fully opens)
    3) Paste the Username and Password on the webform & click on "Go" to submit.
    4) Click on "Inbox","Order" & "Logout" respectively.

    Repeat the same procedure with all the Usernames & Passwords

    Sorry if this question seems idiotic but I'm lost.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •