terrypin Posted May 11, 2013 Report Share Posted May 11, 2013 I don't use the On Error routine very much, so perhaps the following has an obvious answer. I have a macro that first opens a folder and thought I'd better include a check for the folder's existence. But it never seems to get executed, even when the folder plainly doesn't exist as in this simplified example: Open Folder to "Q:\xyz\abc" // On Error set to 'The path does not exist', 'Handle error'.On Error Catch Error: The path does not exist Text Box Display: // Display "The folder doesn't exist." End Catch ErrorEnd Error Also, if I set the On Error option to Prompt for action in the Open Folder command, no prompting occurs. In summary, if a non-existent folder is specified in the Open Folder command, the macro just sails through and ignores it. --Terry, East Grinstead, UK TestOpenFolderPuzzle.mex Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.