August 2019
How To Find Certain Files In VBA
Someone wanted to loop through the files in over 100 directories and find a list of their powerpoint files. This code will loop a specific directory and check if a file with a “pptx” extension exists in that directory. If it does, a message box will be displayed. Instead of the message box, the file’s […]
How To Identify The Last Row Worked On (VBA Variable Scope)
So, I had an interesting question regarding how to find the last row the user was working on before the closed the form, so when the reopen the form, they could continue to work on that record. (This is actually expanding on an example I showed: https://vbahowto.com/how-to-highlight-the-current-row-in-a-continuous-form-in-3-steps/) The the following code will demonstrate one way […]