Consulting

Results 1 to 2 of 2

Thread: fso.CopyFile Errors 70/76

  1. #1
    VBAX Contributor
    Joined
    Jul 2017
    Location
    Zurich
    Posts
    132
    Location

    fso.CopyFile Errors 70/76

    Hi folks

    I'm trying to save a copy of the active workbook via fso.CopyFile (Source as String, Destination as String) method.

    This works as expected with local files. However, the source file needs to be on a network share. So there seems to be an issue with the source path.

    I've tried the following so far:

    http://apps.xyz.net/ch/qms/Work/File Name.xlsm 'Error 76, Address retrieved from ThisWorkbook.FullName
    http://apps.xyz.net/ch/qms/Work/File%20Name.xlsm 'Error 76
    \\apps.xyz.net\ch\qms\Work\File%20Name.xlsm 'Error 70 , UNC converted
    \\apps.xyz.net\ch\qms\Work\File Name.xlsm 'Error 70

    Any ideas?

  2. #2
    VBAX Contributor
    Joined
    Jul 2017
    Location
    Zurich
    Posts
    132
    Location
    Solved it by using

    ThisWorkbook.SaveCopyAs (Destination)
    So I don't need to worry about the network path

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •