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.selectedIndex,
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
(E-Mail Removed)
"RudyShoe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.selectedIndex,
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.selectedIndex,
> 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" <TungChe...@Invalid.com> 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" <scottschumac...@verizon.net> wrote in messagenews:(E-Mail Removed)...
>
> > 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.selectedIndex,
> > 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <TungChe...@Invalid.com> 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" <scottschumac...@verizon.net> wrote in
messagenews:(E-Mail Removed)...
> >
> > > 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.selectedIndex,
> > > document.welcome.ACTION.selectedIndex, 'i.web', 'ipre-ssl.web', 'no',
> > > '')">
> >
> > > Any ideas?
> >
> > > Thanks,
> >
> > > Scott
>