External files cause errors, how do I skip them?

Hello Excel experts!

I am working on a PowerPoint file lister, but some of these pptx files are bad. They cannot be opened, and therefore cause errors in my code. I cannot seem to find a method to say "I this line errors, just skip further down to here". All error handling solution I can see are general for the Sub and is not specialised for errors in a single line. I am looking for the VBA equivalent of IFERROR().

The line in my code that sometimes errors is:

Please Login or Register  to view this content.

I have checked the files when it happens, and these files cannot be opened. My code is otherwise working well.

Here is my full Sub for reference:

Please Login or Register  to view this content.

I hope You can help


GregersDK

Hi there,

This is untested, but perhaps modifying your code as follows might help:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

That totally worked, thank you!

I don't totally understand it, but I have a general gap in my VBA knowledge when it comes to errors.

Hi again,

Many thanks for your feedback - glad I was able to help.

Ok, we accept the fact that the following statement may fail occasionally (e.g. if the target file is corrupted),

Please Login or Register  to view this content.

so we temporarily suspend Excel's normal error handling (i.e. Excel won't bother to generate an error message when it "discovers" that it can't open the target file.)

When Excel can't open the target file it won't be able to assign any value to the object variable "myPresentation", so its value will remain as the "Nothing" set in the preceding statement.

We immediately re-enable Excel's normal error handling (On Error GoTo 0) so that any further errors will be handled in the normal way.

We continue with processing only if the target file was opened successfully, i.e. if the object variable "myPresentation" does NOT have a value of Nothing.

Regards,

Greg M