autorun macro after dde

gumby
02-17-2003, 08:48 AM
Hi, This is my first time and I am new at this.
I am opening an Excl file automatically at night. When it opens I am transfering data from other sources via dde. My problem is the macro runs before my data gets transfered. How can I delay running the macro untill all my data is transfered. "appx.5 secs."
Any help would be appreciated.

Timbo
02-17-2003, 09:05 AM
Get the macro to loop a 'DoEvents' routine until the source files have closed... or if those source file are XL workbooks, you could have them set a public variable in your master file when they're closed...

gumby
02-17-2003, 09:18 AM
Thanks, Timbo. I'll give it a try.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum