VBA Code Sequence Question

In the following Code, would the "Exit Here:" code run even if there is no error? Because sometimes I get an error when I have my close in both places.

Please Login or Register  to view this content.

Thanks in advance,

Dan

Sure. You need an Exit Sub before Exit Here.

And this is a preferable declaration:

Please Login or Register  to view this content.

Thank you this answers my question perfectly!!!
I can use the preferable, side note question. Why? i.e. why have 2 statements to do one?

Thanks in advance,

Dan

Another question on topic:

Since my code seems to be buggy at best. (i.e. I am learning)

I want to ensure I close connections even if there is an error. I learned that if the .close and =nothing are after the resume exithere, then I end up in an endless loop.

So should I use:

Please Login or Register  to view this content.

Thanks in advance,

Dan

Why? i.e. why have 2 statements to do one?

Read this code and decide what the two msgboxes should say. Then run it.

Please Login or Register  to view this content.