Web pop up

F

fi.or.jp.de

Hi All,

I running macro to get data from web.

step 1 - I will provide login info in excel
step 2 - Once i run the macro, it will open the web page ( Company
web)
step 3 - inputs login info
step 4 - goes to tab ( accounts )
step 5 - finds some accounts
step 6 - clicks save to pdf account.
step 7 - open new pop window & asks to click ok.

I am able to complete till step 6.
step 7 opens new pop window & i am not able write code to click ok.

How can i achieve this.

This company url - so, i can't paste the url here.

Please help me
 
J

joel

Once a person manually navigates on a webpage the connection is los
between the macro code and the webbrowser. If there is only one we
browser open you can find the web browser application by searcin
through the active processes (the same as if you were using the tas
manager). You can also find the application by using the title of th
windows.

The window is the parent to the web application. so once you find th
title of the correct window use the following

AppActivate title[, wait]

You can themn use Active window to get control of the window in VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top