Can't rename with different drive (Error 74)
The Name statement must rename the file to the current drive. This error has the following cause and solution:
- You tried to move a file to a different drive using the Name statement. Use FileCopy to write the file to another drive, and then delete the old file with a Kill statement.
For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.