Capture data in another non-Excel window

W

wfariss

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
 
P

Patrick Molloy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Excel capture a screenshot? 2
using Forms and VBA within Excel 3
Excel Macro 1
Open a word mail-merge document from Excel VBA 1
Regex Capture problem 6
Spaces in data entry 6
Run Macro (VBA) every 5 minutes 1
How to capture Excel Save As dialog box? 7

Top