Prevent Do While loop from doing a Go to Error

[amphinomos]

Hi,

I've got the following code which opens/gets the excel files from a specified directory and imports them into an open workbook. I've added a GoTo Error before my loop which checks if there are any files in the directory and shows an error message if it's the case. Problem is since the loop goes on till there are no more files in the directory, it goes back to the error. Any ideas on how to change that ?

Please Login or Register  to view this content.

Thanks,
amphi

[ragulduy]

Put exit sub at the end of the loop, i.e.:

Please Login or Register  to view this content.

Edit:
or

Please Login or Register  to view this content.

and get rid of the goto bit

[Solus Rankin]

The line after Error: will run every time the loop is complete whether or not there is an error.

[amphinomos]

Thanks ragulduy! I went with the second option as I still had some procedures to run after the loop.