hi guys
some of you may remember this thread
http://www.excelforum.com/showthread.php?t=641622
i have a macro that saves specifically to a folder
that contains a job number and customer name
ie \\server\job_file\J5212 - Sumner\docs
i have encountered a problem where the name is spelt differently
the folder is actually called j5212 - sumner
but if i type j5212 - summer it wont obviously save and comes up with an error because of the spelling mistake
despite my folder being as it is
is there anyway i can get this to save to the folder with just the j5212??
Bookmarks