Copy Excel data to web page

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 22, 2004

• #2

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.

 

Upvote 0

M

marktimm22

New Member

Joined

Sep 22, 2004

Messages

18

• Sep 22, 2004

• #3

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

 

Upvote 0

M

marktimm22

New Member

Joined

Sep 22, 2004

Messages

18

• Sep 22, 2004

• #4

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

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 22, 2004

• #5

On your hard drive.

Which line lit up in debug mode?

 

Upvote 0

M

marktimm22

New Member

Joined

Sep 22, 2004

Messages

18

• Sep 22, 2004

• #6

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?

 

Upvote 0

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 22, 2004

• #7

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.

 

Upvote 0

dscheste

Board Regular

Joined

Jul 10, 2004

Messages

206

• Sep 22, 2004

• #8

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?

 

Upvote 0

M

marktimm22

New Member

Joined

Sep 22, 2004

Messages

18

• Sep 22, 2004

• #9

<-- 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.

 

Upvote 0

M

marktimm22

New Member

Joined

Sep 22, 2004

Messages

18

• Sep 22, 2004

• #10

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

 

Upvote 0