filecopy - error 76 Path not found

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I am trying to do a filecopy from within Access of a
spreadsheet and need to use the UNC instead of the mapped
drive since not everyone has the same mappings since this
application is being used by many companies. However I am
getting error number 76 path not found on it. Any
suggestions as to how I can make this happen?
Thanks,
Diane
 
It works ok for me. Check your syntax? Try mapping to
the location to check the validity of your UNC path.

FileCopy "C:\mySheet.xls", "\\sys3\data\myCopy.xls"
 
I believe you'll get an Error 76 if you don't have access to either the
source or the target.
 
Back
Top