Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Peek at data in open excel sheet
hello,
how may one use a VC or VB program or whatever to peek at data (columns and rows) in an open worksheet. So not the data of the stored worksheet but of the copy in memory shall be peeked (read). Thank you for your help. Regards Ralph Rüberg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Peek at data in open excel sheet
What do you want to accomplish? HTH Otto
"ralph rueberg" wrote in message ... hello, how may one use a VC or VB program or whatever to peek at data (columns and rows) in an open worksheet. So not the data of the stored worksheet but of the copy in memory shall be peeked (read). Thank you for your help. Regards Ralph Rüberg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Peek at data in open excel sheet
Deutsch? Also:
Möchte ein Excelsheet mit laufend (per DDE-Link) aktualisierten Aktienkursen mit einem Programm in bestimmten Zeitintervallen lesen und in der aufrufenden Applikation weiterverarbeiten. Das Excelsheet ist gestartet, also offen, und enthhält Daten wie Aktiensymbol, letzter Kurs, Briefkurs etc., Volumen und ist völlig gleichartig gestaltet. Derzeit mache ich einen "unload" in ein Datenfile, was mir aber zu umständlich und zeitraubend erscheint. Für eine Idee wäre ich sehr dankbar. Freundliche Grüße Ralph Rüberg -----Original Message----- What do you want to accomplish? HTH Otto "ralph rueberg" wrote in message ... hello, how may one use a VC or VB program or whatever to peek at data (columns and rows) in an open worksheet. So not the data of the stored worksheet but of the copy in memory shall be peeked (read). Thank you for your help. Regards Ralph Rüberg . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Peek at data in open excel sheet
The Excelsheet is updated at certain time intervals by a
DDE-Link (Stock quotes and related data). I would like to read in the continuosly updated information into a calling program and process them there later on. Currently I am doing an unload into a data file which somehow seems to me to be too time consuming and fussy. Would be very thankful for any idea. Regards Ralph Rueberg -----Original Message----- What do you want to accomplish? HTH Otto "ralph rueberg" wrote in message ... hello, how may one use a VC or VB program or whatever to peek at data (columns and rows) in an open worksheet. So not the data of the stored worksheet but of the copy in memory shall be peeked (read). Thank you for your help. Regards Ralph Rüberg . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
0.9514756 Peek Inside And Realize That Dream ... 9.033287E-02 | Setting up and Configuration of Excel | |||
When I open Excel I want it to open on Sheet 1 | Excel Discussion (Misc queries) | |||
Create, name, open, and enter data in new sheet - from template | Excel Discussion (Misc queries) | |||
will VLookup peek over it's shoulder? | New Users to Excel |