PDA

View Full Version : Fill web form from Excel



black_smith
12-06-2012, 10:10 PM
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.

black_smith
12-07-2012, 02:05 AM
:( Still no reply. Please tell me if any further information is needed.


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.