Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE link
I'm useing DDE to obtain some data from a program via VBE(code below).
activecell = "=metalink|read.csc!'hobby\dcp1-f'" When this is ran it brings back a number however sometimes it brings back a "#N/A". If this is done with step Into and the "#N/A" comes up, I just wait a few seconds before pressing F8 again and the data has time to be returned. However when running the macro normally the data does not seem to have time to return. is there any way to pause and give the DDE time to return data? thanks for any help. Darron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE link
Look in Excel VBA help at the Wait command. As I recall, it allows a process
like DDE to continue. -- Regards, Tom Ogilvy "Darron" wrote: I'm useing DDE to obtain some data from a program via VBE(code below). activecell = "=metalink|read.csc!'hobby\dcp1-f'" When this is ran it brings back a number however sometimes it brings back a "#N/A". If this is done with step Into and the "#N/A" comes up, I just wait a few seconds before pressing F8 again and the data has time to be returned. However when running the macro normally the data does not seem to have time to return. is there any way to pause and give the DDE time to return data? thanks for any help. Darron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Link to external link | Excel Worksheet Functions | |||
Q: Changing a link without link validation | Excel Programming |