ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clicking submit button on web page (https://www.excelbanter.com/excel-programming/382193-clicking-submit-button-web-page.html)

RudyShoe

Clicking submit button on web page
 
Okay, I've tried everything that I've been able to dig up on this
forum but haven't had any success. I've been able to log into a
website, select items from a couple of drop downs but i'm hung up at
the submit button on this particular page. No issues using the submit
button on the login page however. The only difference I see between
the submit button on the login page and the submit button on the drop
down page is that the drop down page submit button has an 'onClick'
statement. The login page didn't have this.

I've tried the following....
ie.document.all.Item("welcome").submit <---'welcome' is the
name of the form
* I receive a 'Action code not submitted' error on the webpage. I'm
assuming this is occuring since i'm not actually clicking the submit
button.

I've also tried.....
Set ipf = ie.document.all.Item("submit")
Call ipf.Click()
* I receive a 'Run-time error '91': Object variable or With block
variable not set' error


Here's a snippet from the website...
<INPUT TYPE="submit" VALUE="Submit"
onClick="process_form(document.welcome.DATABASE.se lectedIndex,
document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
'')"

Any ideas?


Thanks,

Scott


Don Guillett

Clicking submit button on web page
 
Perhaps if you gave the url and the EXACT table (or how to get to it) you
can get some comments.

--
Don Guillett
SalesAid Software

"RudyShoe" wrote in message
oups.com...
Okay, I've tried everything that I've been able to dig up on this
forum but haven't had any success. I've been able to log into a
website, select items from a couple of drop downs but i'm hung up at
the submit button on this particular page. No issues using the submit
button on the login page however. The only difference I see between
the submit button on the login page and the submit button on the drop
down page is that the drop down page submit button has an 'onClick'
statement. The login page didn't have this.

I've tried the following....
ie.document.all.Item("welcome").submit <---'welcome' is the
name of the form
* I receive a 'Action code not submitted' error on the webpage. I'm
assuming this is occuring since i'm not actually clicking the submit
button.

I've also tried.....
Set ipf = ie.document.all.Item("submit")
Call ipf.Click()
* I receive a 'Run-time error '91': Object variable or With block
variable not set' error


Here's a snippet from the website...
<INPUT TYPE="submit" VALUE="Submit"
onClick="process_form(document.welcome.DATABASE.se lectedIndex,
document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
'')"

Any ideas?


Thanks,

Scott




NickHK

Clicking submit button on web page
 
I'm no web expert, but the HTML looks like it is calling a javascript
routine.
Maybe you can duplicate that behaviour.

NickHK

"RudyShoe" wrote in message
oups.com...
Okay, I've tried everything that I've been able to dig up on this
forum but haven't had any success. I've been able to log into a
website, select items from a couple of drop downs but i'm hung up at
the submit button on this particular page. No issues using the submit
button on the login page however. The only difference I see between
the submit button on the login page and the submit button on the drop
down page is that the drop down page submit button has an 'onClick'
statement. The login page didn't have this.

I've tried the following....
ie.document.all.Item("welcome").submit <---'welcome' is the
name of the form
* I receive a 'Action code not submitted' error on the webpage. I'm
assuming this is occuring since i'm not actually clicking the submit
button.

I've also tried.....
Set ipf = ie.document.all.Item("submit")
Call ipf.Click()
* I receive a 'Run-time error '91': Object variable or With block
variable not set' error


Here's a snippet from the website...
<INPUT TYPE="submit" VALUE="Submit"
onClick="process_form(document.welcome.DATABASE.se lectedIndex,
document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
'')"

Any ideas?


Thanks,

Scott




RudyShoe

Clicking submit button on web page
 
I'd post the site if it was available but it's on my company's
intranet.

Nick, you're right, it is javascript. Is there a way to duplicate the
behavior from within Excel?

On Jan 29, 5:41 pm, "NickHK" wrote:
I'm no web expert, but the HTML looks like it is calling a javascript
routine.
Maybe you can duplicate that behaviour.

NickHK

"RudyShoe" wrote in ooglegroups.com...

Okay, I've tried everything that I've been able to dig up on this
forum but haven't had any success. I've been able to log into a
website, select items from a couple of drop downs but i'm hung up at
the submit button on this particular page. No issues using the submit
button on the login page however. The only difference I see between
the submit button on the login page and the submit button on the drop
down page is that the drop down page submit button has an 'onClick'
statement. The login page didn't have this.


I've tried the following....
ie.document.all.Item("welcome").submit <---'welcome' is the
name of the form
* I receive a 'Action code not submitted' error on the webpage. I'm
assuming this is occuring since i'm not actually clicking the submit
button.


I've also tried.....
Set ipf = ie.document.all.Item("submit")
Call ipf.Click()
* I receive a 'Run-time error '91': Object variable or With block
variable not set' error


Here's a snippet from the website...
<INPUT TYPE="submit" VALUE="Submit"
onClick="process_form(document.welcome.DATABASE.se lectedIndex,
document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
'')"


Any ideas?


Thanks,


Scott



NickHK

Clicking submit button on web page
 
Not sure. Hunt around in the IE object model.
Maybe this:
http://www.dotnet247.com/247referenc...44/220707.aspx

NickHK

"RudyShoe" wrote in message
oups.com...
I'd post the site if it was available but it's on my company's
intranet.

Nick, you're right, it is javascript. Is there a way to duplicate the
behavior from within Excel?

On Jan 29, 5:41 pm, "NickHK" wrote:
I'm no web expert, but the HTML looks like it is calling a javascript
routine.
Maybe you can duplicate that behaviour.

NickHK

"RudyShoe" wrote in

ooglegroups.com...

Okay, I've tried everything that I've been able to dig up on this
forum but haven't had any success. I've been able to log into a
website, select items from a couple of drop downs but i'm hung up at
the submit button on this particular page. No issues using the submit
button on the login page however. The only difference I see between
the submit button on the login page and the submit button on the drop
down page is that the drop down page submit button has an 'onClick'
statement. The login page didn't have this.


I've tried the following....
ie.document.all.Item("welcome").submit <---'welcome' is the
name of the form
* I receive a 'Action code not submitted' error on the webpage. I'm
assuming this is occuring since i'm not actually clicking the submit
button.


I've also tried.....
Set ipf = ie.document.all.Item("submit")
Call ipf.Click()
* I receive a 'Run-time error '91': Object variable or With block
variable not set' error


Here's a snippet from the website...
<INPUT TYPE="submit" VALUE="Submit"
onClick="process_form(document.welcome.DATABASE.se lectedIndex,
document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
'')"


Any ideas?


Thanks,


Scott






All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com