Export data from excel to IE form
 

Hi All,

I have a situation where I need to I have to upload text from a excel
file to a web based portal. There are about 300 + such sheets that I
need to upload and each sheet has around 100 such cells that need to be
uploaded or filled in the web based application.

What I need to do is take the data from each cell, copy the same and
paste the same in the corresponding textbox in the IE application. The
web based application has drop down lists, textboxes and checkboxes.
The excel sheet also has a corresponding cell that pertains to each
item. For eg. I need to put the data from cell A1 (for example) into
the first dropdown then the data for cell b1 goes to the next textbox
then the data for cells c1 to c10 go to the 10 checkboxes (whereever
applicable) to the checkboxes then I have another cell M1 which goes to
the next textbox in IE and finally I have 4 drop downs with values
which need to go the corresponding 4 dropdown boxes in the web
application. This information comprises 1 row of information. Each
excel sheet could have around 8 - 10 such rows. The webapplication has
the ability to insert more rows if required (manually). Hence I dont
mind inserting the extra rows (incase I have more than 10 rows in my
excel sheet) first in the application and then run the macro.

Incase someone is interested to give this a try, I would be glad to
send the screenshots of both the excel sheet and the webapplication
(with sourcecode i.e. .NET page).

Appreciate any help in this regard.

regds
Shuvro