Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture data in another non-Excel window
Aside from DDE or third party application, is there any Excel/VBA
solution to automating the capture of data from a separate window into an Excel spreadsheet. I have a situation in which I can run a report from an application and that report (data) will then show in a separate window. I am attempting to automate the capture of that windows' data and put it in a spreadsheet. I need to automate this capture. Any help would be appreciated. - Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capture data in another non-Excel window
Maybe the speadsheet that creates the table should output the data into a
text file that the other spreadsheet could import? synchronising will be one issue. " wrote: Aside from DDE or third party application, is there any Excel/VBA solution to automating the capture of data from a separate window into an Excel spreadsheet. I have a situation in which I can run a report from an application and that report (data) will then show in a separate window. I am attempting to automate the capture of that windows' data and put it in a spreadsheet. I need to automate this capture. Any help would be appreciated. - Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I capture the workbook window? | Excel Discussion (Misc queries) | |||
Scheduled data capture in Excel | Excel Worksheet Functions | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
EXcel Capture Data into one cell | Excel Worksheet Functions | |||
Capture and Store the date that data is entered in Excel? | Excel Worksheet Functions |