View Single Post
 
Old 12-27-2020, 02:01 AM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
You miught have missed off the last /

adjusted the code slightly, now try
It works now, but my understanding of VBA is too low. I'm currently going through tutorials to get a better understanding of this so I can apply it at work. Specifically, I tried to recreate the macro in a new file and folder and got the same error message. Below are the two new files.

I might need to simply learn more before advancing in this topic.
Attached Files
File Type: xlsx MsForums1.xlsx (82.8 KB, 5 views)
File Type: xlsx MsForums2.xlsx (8.7 KB, 5 views)
Reply With Quote