Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Excel Macro question | Excel Programming | |||
Excel macro question | Excel Programming | |||
Excel Macro question | Excel Discussion (Misc queries) | |||
Excel Macro Question | Excel Programming |