Great video. Should be watched if you want to learn VBA. Remember you can download the exercise files as many times as you want. Keep at it. It's worth it.
You're good either way! Our original VBA videos are still super relevant. At the same time, our new ones are created in a more recent version of Excel with all the new features and tweaks that come with it. Wishing you well on the prepping!
at 31.03 I don't quite understand how it can exit the sub procedure when it finds an error? Surely when it hits the error the code jumps out of the procedure to ErrorHandler and bypasses the exit sub? When I ran the code, I got the following error message, without an error number: "Sorry, we couldn't find " followed by the filepatrh and filename. After I clicked OK on that, I then got the error message as defined in the code i.e "The Reports Workbook is not available."! So it would seem that I got the else error first and THEN the error designed to replace error 1004! Could this be because the version of Excel I am using is from Office 365 in September 2022 and is this different from Excel 2019?
FOLLOWUP: I put a breakpoint on the On ERROR GOTO Line and sure enough, when I ran the code, when it hit the error, it missed the Exit Sub line and went straight to the ErrorHandler. I then renamed the Reports2 file back to Reports and re-ran (without removing the breakpoint and used the F8 key to step into the code. It was only after completing all of the steps that it hit the Exit Sub line (which is what I assume the intention was? i.e if there is NO error, then it has to bypass the code for ErrorHandler) and I may have then misunderstood your explanation., although you DID say that the Exit Sub would only kick in if there WAS an error "we don't want it to keep running the sub procedure"!
Great video. Should be watched if you want to learn VBA. Remember you can download the exercise files as many times as you want. Keep at it. It's worth it.
Thanks for the info!
thank you very much!
You are very welcome!
I need to prep for a job so a couple weeks ago I watched the course made a few years ago from this channel. Do I need to watch all these videos?
Vba in excel course from this channel i mean
You're good either way! Our original VBA videos are still super relevant. At the same time, our new ones are created in a more recent version of Excel with all the new features and tweaks that come with it. Wishing you well on the prepping!
at 31.03 I don't quite understand how it can exit the sub procedure when it finds an error? Surely when it hits the error the code jumps out of the procedure to ErrorHandler and bypasses the exit sub? When I ran the code, I got the following error message, without an error number:
"Sorry, we couldn't find " followed by the filepatrh and filename. After I clicked OK on that, I then got the error message as defined in the code i.e "The Reports Workbook is not available."!
So it would seem that I got the else error first and THEN the error designed to replace error 1004! Could this be because the version of Excel I am using is from Office 365 in September 2022 and is this different from Excel 2019?
FOLLOWUP: I put a breakpoint on the On ERROR GOTO Line and sure enough, when I ran the code, when it hit the error, it missed the Exit Sub line and went straight to the ErrorHandler.
I then renamed the Reports2 file back to Reports and re-ran (without removing the breakpoint and used the F8 key to step into the code. It was only after completing all of the steps that it hit the Exit Sub line (which is what I assume the intention was? i.e if there is NO error, then it has to bypass the code for ErrorHandler) and I may have then misunderstood your explanation., although you DID say that the Exit Sub would only kick in if there WAS an error "we don't want it to keep running the sub procedure"!
Thanks for the notes! We will look into it!