View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_82_] joel[_82_] is offline
external usenet poster
 
Posts: 1
Default Excel Macro Question


Are these web browser windows or regular windows? what application is
running? the data need to be text (not graphics).

I can show you how to activate each window, but not sure I can get the
data of the screen. You would ned to run a win32 dll to get all the
active processes from the Task Manager. You can activate the each
window using the VBA command using "AppActivate title or Process ID".
You don't need to get the process ID if you know the title on each
window. but then you can only copy the window and paste if into excel
or use SendKeys. If yo can use Sendkeys to same the data into a
temporary file (CSV fromat) that would make things simple.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147488