Excel Macro Question

[brianDY]

Does anyone know how to make a scrapeing macro? what i need is a macro to run
that will run through multiple screens in a system outside of excell and
scrape data and then plug it into certain excel cells ..I hope that made sense

 

[joel]

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.