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.
[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]