Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I capture the workbook window? Stacy Excel Discussion (Misc queries) 1 December 2nd 08 08:12 AM
Scheduled data capture in Excel jc132568 Excel Worksheet Functions 3 March 5th 08 02:59 AM
Excel screen capture to capture cells and row and column headings jayray Excel Discussion (Misc queries) 5 November 2nd 07 11:01 PM
EXcel Capture Data into one cell Luis Excel Worksheet Functions 0 April 19th 06 05:25 PM
Capture and Store the date that data is entered in Excel? Nicegy Excel Worksheet Functions 2 August 10th 05 12:58 AM


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"