DDE link

[Guest]

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

 

[Guest]

Look in Excel VBA help at the Wait command. As I recall, it allows a process
like DDE to continue.