Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What DDE topic returns the currently open file?
I'd like to know that myself!
As a workaround I use "Selection" which returns something like "[myBook.xls]!R1C1" then I get the filename between the brackets Regards, Peter T "The Chemist" <The wrote in message ... I developed an application years ago that uses DDE to converse with Excel. I used to be able to send a DDE request using the topic "TOPICS", and it would return a string that contained the name of the spreadsheet file that was currently open. Now, this command returns an error with Excel 2003. Any ideas?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What DDE topic returns the currently open file?
Typo -
"[myBook.xls]!R1C1" missed the sheet name - "[myBook.xls]Sheet1!R1C1" Peter T "Peter T" <peter_t@discussions wrote in message ... I'd like to know that myself! As a workaround I use "Selection" which returns something like "[myBook.xls]!R1C1" then I get the filename between the brackets Regards, Peter T "The Chemist" <The wrote in message ... I developed an application years ago that uses DDE to converse with Excel. I used to be able to send a DDE request using the topic "TOPICS", and it would return a string that contained the name of the spreadsheet file that was currently open. Now, this command returns an error with Excel 2003. Any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to url returns error: cannot open the specified file | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming |