Copy Excel data to web page

[marktimm22]

Excel 2003, Windows XP:

I have 10 columns of address information in Excel. I need to copy the contacts of the columns into a web page that I have no control over. (I can not change the page) In other words, I am filling out a web form with the contents of row 2, hitting accept, then filling out the web page with row 3, etc...

Can this be done with Excel, or do I need to get another product/device?

Thanks!!!

 

[NateO]

Welcome to the board.

You will need to look at the web page's source code to figure out the inputs. See the following:

http://www.mrexcel.com/board2/viewtopic.php?t=101460&start=7

Note:

.UserName.Value = "Your Login ID"

Could just as easily be:

.UserName.Value = range("a3").value

for example.

 

[marktimm22]

Thank you for the welcome and for the help! I'll give it a try. Mark

 

[marktimm22]

I get an error. Do I need to have Internet Exploryer is a paticular location?

 

[NateO]

On your hard drive.

Which line lit up in debug mode?

 

[marktimm22]

It goes from .UserName.Value = "marktimm22" to the error sub. Also, the web site I am entering data into in a https. Does that matter?

 

[NateO]

No, don't think so. Are you sure that's the correct field name? There's no default, it depends out the developer built the site eh.

 

[dscheste]

Hey, Mark,

you can definitely do it in excel

Do you have access to the backoffice database the website is running on? You could plug in the values directly into it bypassing the html stuff alltogether. Nimrod had some nice code for SQL here.

https should not present any problem, could you please use the HTML maker for the forum and quote the html response code to have a look as where the values should be put and sent to the server?

 

[marktimm22]

<-- Love this guy..

This is what I am trying to do... I am logging on to the fedEx web site, which I have no control of. After I log in, I have to enter about ten fields of data from an Excel sheet to populate the address and claim information fields. Currently, I am doing a cut/paste. I need to do this several hundred times. Since I don't have access to change the web site code, I just wanted to see if I could automate the copy/paste process. I might be able to do this with a hardware device, like a Symbol OmniLink. Any help is GREATLY appreciated. Mark

P.S. adding to my wish list, I would also like to have some of the drop downs auto selected but I can do them manually.

 

[marktimm22]

This is some code I found but it gets stuck on the last while-wend. I thought this might be a good start but it doesn't even work.

Sub LoginMe()

Dim appIE As Object

Set appIE = CreateObject("InternetExplorer.Application")
appIE.Visible = True

While appIE.busy
DoEvents
Wend

appIE.navigate "https://access.leggmason.com/"

While appIE.ReadyState <> READYSTATE_COMPLETE
DoEvents
Wend

SendKeys "excel", True
SendKeys "{TAB}", True
SendKeys "hello", True
SendKeys "{ENTER}", True

End Sub