Prev: Auto_Open over Private Sub Workbook_Open()
Next: Stopping a timer
From: fi.or.jp.de on 29 May 2010 15:07
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
From: joel on 29 May 2010 15:23

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

The window is the parent to the web application. so once you find the
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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=206078

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Auto_Open over Private Sub Workbook_Open()
Next: Stopping a timer