Copy cell content from Excel to opened webpage

Hi All,

I am relatively new to VBA, but I am trying to create a macro that will copy cells from my excel sheet to input fields on an already opened webpage and submit the data. Basically I need to fill out my daily production sheet.

I am working in Excel 2010.

1. Copy a cell content (A1)
2. Go to internet and paste it in the specified field
3. Go back to excel and copy cell content (B1)
4. paste in the web form.
5. Submit and start filling next from cell A2.

Web form has these fields

Date (Date Field - mm/dd/yyyy):
Type of Operation (Radio Button to select):
Type of Work (Dropdown):
Prod ID (Text Field):
Prod Page (Text Field):
Submit and Cancel (Buttons)


Please help me on this.

All your help will be much appreciated.

Thanks,
Pradeep

Workspace Macro Pro -> use that program. I use it very often for such uses when I need to copy something from Excel to SAP and do not have any import solution available. The I do a recording of changing windows and copy paste actions and just run that program 10-15-20-100 thousand times and go to coffee :D

Problem is that with VBA itself you cannot change programs and send some value from one window to another. With .NET yes, but VBA no.