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

Excel - Wich Function should I use? 1
Prevent loss of SetPixel changes by window repaint 0
Dates In Excel 5
Can Excel capture a screenshot? 2
Linking data in MS Word into Excel 5
Found few bugs in my daily routine of work in excel for MAC 0
Need Help with a VBA subroutine 0
Possible to Combine reports to's to a single box? 0

Top