I don't use DDE much an very much less likely too because of other applications interfering with the DDE communications. I did have issues with the some DDE commands when we changed versions of Office because some of the actions in the DDE commands really wanted the proper file type notification such as to do a file save as command if the file type did not match the current version of Excel I would get similar Excel prompts. Every version of Excel pretty much had a specific type and xlsx and xlsm are different. Since your code is quite different from what I used I can't be sure exactly where such might be needed but I suspect something around the QUIT might be needed. Perhaps an explicit save command would help as well. ... View more