• Have you tried to increase the OLE/DDE timeout value? Just a guess but worth a try. The following example sets the timeout value 60seconds.

    Application.SetOption "OLE/DDE Timeout (Sec)", 60