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

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

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

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

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