This video is a response to a comment on another video at https://www.youtube.com/watch?v=98t1yLUwmEo&lc=z13oevyrxxiyjpjdd221jthigmnmghv3l
“Hello, where can I add code to open a specific excel document?”
There is a more useful option to the Shell function, because I don’t have to
name the file to open, and it’s already built in to Microsoft Office.
You can download the Excel file here:
Click here for the database and the code:
File Open Shell VBA
Here is another way to open a specific file using the traditional MS Office File Open Dialog
If you have a suggestion for a future video, contact me on my contact form, and I will seriously consider it.