Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDERequest: Interesting Predicament
Hi - i have an interesting problem.
DDERequest returns an array of data, when used via Excel. I have a program which accepts DDEExecutes, and stores the return value in DDEText. This is a database program. If I wanted teh first name of the entry, here's what it'd look like. dim Oad as Long oad = DDEInitiate("oadbook","accel") DDEExecute oad,"Getname First" mystr = DDERequest(oad,"DDEText")(1) <- 1st item in returned array. DDETerminate oad msgbox mystr returns say "John" that works. Fine, fine and dandy. With cherries too.. however, here's the glitch, and as much info as I can tell. There's a Notes section. Word (which doesn't return an array with DDERequest) can handle DDEExecute oad, "Getnotes all" msgbox DDERequest(oad,"DDEText") DDETerminate Following the logic, it stands DDERequest(oad,"DDEText")(1) would work in Excel. Wrong. If I do ubound, it corresponds to the number of CR's (hard returns) in the Notes section. So I think Excel's DDEREquest uses CR's to seperate stuff in an array. If this is so, how can I make it NOT do that? =) any ideas? I need to get those notes, and don't want to have to fire a Word instance, and a small sub just to do it. Thanks for any ideas. =D -Khai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with an interesting chart | Charts and Charting in Excel | |||
Interesting Median observation | Excel Discussion (Misc queries) | |||
Interesting situation help required!! | Excel Discussion (Misc queries) | |||
another interesting thing... | Excel Worksheet Functions | |||
interesting question can anyone help | Excel Discussion (Misc queries) |