Submitting w/o Submit button (Web)

[Todd Bardoni]

I'm trying to query a webpage...

Excel enters the value into the field I want. To submit manually, I have to hit the Enter key since there is no command button on the webpage. How can I have Excel hit Enter automatically? Is this even clear?

 

[Todd Bardoni]

Thanks for spending so much time on this...I really appreciate the effort.

I realized that about the textbox having to be active. Do you know how to activate it so that sendkeys will work? And again, where is some good documentation on Excel/VBA/Webpages? I'm doing this stuff more and more and could really use a lesson...

 

[Von Pookie]

I'm in the same boat with you on trying to figure out how to activate it--if it's even possible. All I've done with VBA/webpages before is to just bring up the page and copy it. I've never had to actually *interact* with a page before.

I can poke around and see if I find anything, though. Now I'm simply curious to see if it can be done

 

[Todd Bardoni]

This...

            Set myTextField = .document.all.Item("txtPart") 
            myTextField.Value = "1229G1619"

...will put in a part number into the Part Number TextBox. I *thought* that woul dbe good enough and that SendKeys would work...but apparently not...

 

[Norie]

Todd

Can you post all the code you currently have?

Have you tried using AppActivate before SendKeys?

 

[Von Pookie]

Norie--code is already posted. At least skim through previous pages in a thread...

 

[Norie]

Kristy

I have been following the post but I couldn't recall if the whole code was posted, I thought it was just snippets.

I'll go and look back.

 

[Norie]

Todd

I think I've got it.

ie.document.forms(0).submit

I found this by first googling 'automating internet explorer from Excel VBA'.

The first link was to an article in **** Kuslekia's blog.

Within the article was this link to the MSDN.

From there I just trawled through the object models till I came to this FORM Element | form Object.

 

[Von Pookie]

Yup, it worked for me!

 

[Todd Bardoni]

That's great! Thanks!

Next question...

Since I can't do a Web Query on this, how can I copy the table?

I was thinking something along the lines of

       .document.Table(1).Value.Copy

...but no go...

 

[Norie]

Todd

I thought you might ask that.

I looked into it a bit but couldn't find anything that jumped out.

I've got a bad feeling it might need to be done by parsing the HTML or something.

I'll have another go later and post back.