Click Yes on opening a webpage

[naveenmarapaka]

Hi below is a simple code which is working to open a URL...

After the page opens, only 2 Buttons will appear,,, please confirm... Yes No

I want to click Yes .. through Code.... how can I do that......

Please Login or Register  to view this content.

[naveenmarapaka]

I tried to add more code and here is my total code now
but still not able to click Yes button......
Showing error as attached pic... Error.JPG and debugging at line...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[naveenmarapaka]

Can i get some help here plss......

[LJMetzger]

Hi,

There's nothing wrong with your code. The web site is busy after executing the following line (waiting for a Username and Password).

Please Login or Register  to view this content.

I get the same runtime error as you running Excel 2003 on a Vista 32 bit system with IE8.

Try the following code, it may get you a little bit further. You need to put in your actual username and password. If you have 64 bit Excel, my code may not compile. Let me know and I'll try to come up with a fix.

If SendKeys doesn't work (you can't run Sendkeys using the debugger), let me know. I have a SendKeys alternative that might work. You will know if SendKeys works if you see your 'User Name' in the 'User Name' box and '*****' in the Password box.

Lewis

Please Login or Register  to view this content.

[naveenmarapaka]

Hi, It wont ask any user name /Password since we already logged in with our user name into pc.....

so after logging in once it wont ask again..... I am using Excel 2013 64 bit in windows 8.....
I am able to navigate to the above URL and the page is displaying which has yes No options to choose ...
Here is my issue, i am not able to select YES button....... in this page.... why my code is not working........

[LJMetzger]

Since you are able to log in, my code won't help you at all. Since I am unable to see the code at the URL, and my URL skills are limited, I don't know what to suggest.

However, SendKeys or a SendKeys alternative may provide a workaround. When you get to the URL that gives you problems, write down what keystrokes you have to use to get the URL to work. SendKeys (or a SendKeys alternative) may be useful. I have no SendKeys experience in Windows 8/ Excel 2013, and SendKeys with Windows 7 occasionally must turn UAC (User Account Control) off to get SendKeys to Work. It is NOT recommended to turn UAC off.

Lewis

[naveenmarapaka]

Hi Lewis hope you can help now... I have changed to below code and its working now....

but some times I get pop up message on webpage termination after clicking Yes button .....
I gets a pop up message "AWB does not exist " or some times pop up message as " AWB already Void"
etc.... pop messages varies all the time....

Here I want to some code to handle this POP UP.. means POP UP message should be closed......


how can I do it....

Please Login or Register  to view this content.

[naveenmarapaka]

Can I get some advise here pls.....

[LJMetzger]

I have no experience with what you are experiencing, so I am not able to advise corrective action. IE automation is tricky, even when it works well.

Sorry, I couldn't be more help.

Lewis

[naveenmarapaka]

Take it as general question, how to deal with Pop up's which usually comes like "Message from Webpage" dialog box
of usually people call it as Child window.. if its appears we need to just close....

Can some one help me here pls.........

[naveenmarapaka]

My project halted as same point still......

[naveenmarapaka]

Hi,
I am still waiting for a solution here...
I just need to click OK..
how to deal with child window which is the title from a javascript alert statement.
"message from webpage"

[jayesh25]

Naveen. Could you try sending Enter key on the IE domain to see if that eradicates the message pop up? Just enter the below after the "Yes" Button is clicked on the VBA Code and test it.

Please Login or Register  to view this content.

[naveenmarapaka]

Jayesh, it's showing error at line AppActivate Ie if there is no pop up window....

its working if there is a pop up message....

what I need is if there is any pop up message then run this code... how can this be possible......

Please Login or Register  to view this content.

[jayesh25]

Naveen if it's working at all times even when Enter isn't required? perhaps try a err resume code?

I'm unsure about the IE return of pop up blocks perhaps i wouldn't be able to test things.

Here's the code you could retry this with. This should erradicate the error bit regardless of no pop up being there

Please Login or Register  to view this content.

[naveenmarapaka]

Jayesh, thanks a million.. you have given me peace...... it worked like a charm.....

[jayesh25]

No problem bro.