Webinar Number: W0013
This webinar features:
- A very specific 7 step process for creating professional quality VBA Macros(even if you are new to VBA).
- Proven techniques that will reduce the time spent fixing errors by 90%.
- The secret to creating a simple framework for your application.
- The little-known, built-in tools you can use to test your code quickly and easily.
- Tons of practical hints and tips you can use right now.
- A Q&A session at the end where I answer all of your questions.
and much more
Related Links
Excel VBA Handbook – Learn VBA by building 10 VBA applications from scratch
The Video
Note: To watch the video at the highest quality, click on HD at the bottom of the video and set to the highest setting.
Hi Paul,
I have noticed in the following code:
If Dir(sFilename)=” “Then
MsgBox “Could not find the workbook: [” & sFilename & “].”
Exit Sub
End If
exits the function before ending the IF statement. Could you please explain why it is the case?
Thank you,
Crystal
The If condition checks if it finds the filename. If the filename does not exist then we obviously cannot continue processing the file so we give display a message to the user and then exit the sub.