Macro From Excel 2013 Not Working in 2016

Good morning All,

I have fiddled with this for about an hour to no avail. I had the below code working flawlessly in Excel 2013 but with a recent upgrade to 2016 I can't get it to work.

Please Login or Register  to view this content.

It appears everything goes as expected until I hit this line where I suspect the problem is and have searched for a fix and tested different variations;

Please Login or Register  to view this content.

Where it will hang on this line for a while until it finally freezes

Please Login or Register  to view this content.

Any hints? Thanks for any help.

Put a loop counter ... get out of jail card ... in there. Increment it and test it for some arbitrary number. There's no way out of your While ... Wend loop until the file appears. Tough if it doesn't show.

Great thank you very much. That does get me out of the loop and prevent freezing.

For whatever reason the program is not firing though, do you see anything wrong with the syntax of the shell command I'm issuing?

I'll plug away at it more after work and report back.

I don't use the Shell command so I can't really comment. I don't have Excel 2013 installed, and I don't have anything to test. So, sadly, I'm not in a position to help or advise.

I would suggest that you put a Stop statement as the first command in the subroutine and then step through using F8. That will allow you to check the contents of variables, etc., at each point and, hopefully, narrow down the issue.

The other thing that might prove useful is to create simple test routines that just check whether or not the Shell commands succeeds in isolation.