1. Have excel sheets, and data in it
2. We have a frame based internet application which has text fields
3. The data from the excel sheet is to be sent to the specific frame in the web page
4. We don’t have control on the web page, ie we don’t have the server access for this web page.
5. I have attached the format of the excel sheet and the screen shot of the web page.
We have to either make a vb program for this or excel macro.
The web page has 30 fields and the excel also will have 30 fields so the data in these 30 fields from the excel is to the sent to the web page, before sending the data the user will enter the mobile no in the web page and the number is to be picked up and searched in the web page for ex in the A column and the 30 fields in the matching row has to be transferred to the web page.
I will forward you the screen shot and the excel sheet in the next mail in another one hr. if you need u can create a web page with 4 frames on one of the frames u can add the fields and the test the application.