Hello everyone,
I have written a macro that saves a file name to a drive using variables. That part of the macro works just fine. I have also written a macro to retrieve the same file using the same variables but I continue to get an error message that the file can't be found and recommends I check my spelling or try a different path. I am using a serial number followed by an extra digit as the variables, example the serial number 12 Build 2 is saved as SN 12 BLD 2. However when I receive the error message, the message adds a ' to the last digit. The message would then say SN 12 BLD 2'. I am not sure this is the problem but it does look suspicious.
I have checked the formatting of the cell I am using to pick up the build number and it is a normal "general" format with no additional text added that I can see. And again, this same cell and format is used to save the original file with no issues.
Can anyone tell me what I might be doing wrong. I have written a very similar macro in the past without running into this problem.
Bookmarks