I have to do a manual saveas before shell and wait function works correctly

Question

I am using an excel vba program to open either a .exe or .bat file. Because I have to wait for the external program to finish before I can continue I am using shell and wait methods I have come across on different user forums. However, independent of the module I use for shell and wait, I cannot open my spreadsheet and run the code directly. I have to do a manual saveas and rename the file; which after doing so my vba code works perfecrtly.

Thanks

Answer 1

I am using an excel vba program to open either a .exe or .bat file. Because I have to wait for the external program to finish before I can continue I am using shell and wait methods I have come across on different user forums. However, independent of the module I use for shell and wait, I cannot open my spreadsheet and run the code directly. I have to do a manual saveas and rename the file; which after doing so my vba code works perfecrtly.

Thanks

Post your VBA question here please:

http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

Thanks

---

Don't judge me, just Upgrade me. Thanks!

Answer 2

Thanks