I figured out the problem. I was using the shared drive letters in my macro (i.e. R:\) but the other user who was getting the error had the shared drive mapped to a different letter. By using the server name instead (i.e. \\servername\) of the drive letter, the macro runs fine. Thank you again for the original code!