DDE Question (OpenInsight 32-Bit)
At 25 NOV 2004 05:41:42AM Colin Rule wrote:
Does anyone know how to use DDE to ask an Excel Spreadsheet to tell it what Worksheets exist in the spreadsheet.
I can find them in a small VBA Macro but that means the code needs to live in the spreadsheet…. which is no fun at all.
Thanks
Colin
At 25 NOV 2004 11:26AM Karl Pozmann wrote:
Colin:
Its been a while since I've played around with this, but you probably need to modify the macro you found to create an invisible sheet to which you post the names of the sheets from tha macro. You can then run the macro from OI and then retrive the data from the hidden sheet.
Maybe there's a more elegant way with OLE….
HTH
At 26 NOV 2004 03:19AM Colin Rule wrote:
Hmm. I was thinking along the same lines, by feeding the results into a cell and then extracting it from there.
Problem is I dont want to have the user need to add a macro to each spreadsheet.
I am wondering if it is possible to embed a small VBA command into a DDE message.
At 26 NOV 2004 04:20AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Colin,
You should be able to drop an OLE control on a form and then set it to talk to Excel via the OLE Automation interface. You should then have the full VBA object model available to you for use with Get/Set_property.
World Leaders in all things RevSoft
At 29 NOV 2004 04:28AM Colin Rule wrote:
OH, forgot to mention…. OI 4.1.
OK OK, I will move to OI 7.1 soon.