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