Message Prompt if Path is invalid

**jp16** · 02-19-2019, 01:22 AM

Hi, i have a getsheet marco where user would type in the path in cell A1 and extract all the xls file.
Below is a extract of my code.
How can i make it that if Path is invalid, there will be a error message "Invalid Path"?

Please Login or Register  to view this content.

**banaanas** · 02-19-2019, 01:56 AM

You can use this function (put in the bottom of the module outside the sub)

Please Login or Register  to view this content.

And in your main code:

Please Login or Register  to view this content.

**jp16** · 02-19-2019, 02:05 AM

Just curious, can we use On Error go to?

**banaanas** · 02-19-2019, 02:20 AM

Of course, you can, but I dislike it. If you run later in the code into problems, then it will show the error go to message, even if it isn't related to it.
Is there a reason why you wan't to use it?

Please Login or Register  to view this content.

Message Prompt if Path is invalid

LinkBack

Thread Tools

Rate This Thread

Display

Message Prompt if Path is invalid

Re: Message Prompt if Path is invalid

Re: Message Prompt if Path is invalid

Re: Message Prompt if Path is invalid

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Invalid path Error when I try to access ADO Recordset

MS Access ADODB Connection String - Invalid File Path, Does not Exist

IF(AND ....) get invalid message

Path name invalid when trying to save a workbook - VBA

Message for invalid entry

[SOLVED] VBA - User prompt to determine path to files

Prompt to select file/path and store as variable

Bookmarks

Bookmarks

Posting Permissions