All,
I have this line in my code, which I have tested both on PC and MAC and works fine. I am trying to copy a file from an existing folder called Templates to a newly created folder (see 2nd snipet of code) and renaming it based on the newly created folder name.
When I tried to run it on a server, I get an error 76 (Path not found).
I really do not understand why as further up in my code, the following works fine both on Mac / PC as well as on server.
I am stumped on this one - any ideas?
Luke
PS: http://www.excelforum.com/excel-pro...aded-on-server-why.html?p=2879037#post2879037
I have this line in my code, which I have tested both on PC and MAC and works fine. I am trying to copy a file from an existing folder called Templates to a newly created folder (see 2nd snipet of code) and renaming it based on the newly created folder name.
Code:
FileCopy ThisWorkbook.Path & Application.PathSeparator & "Templates" & Application.PathSeparator & "PROJECT_DETAIL_SPREADSHEET.xlsm", tr & Application.PathSeparator & .Offset(, -2).Value & "_PROJECT_DETAIL_SPREADSHEET.xlsm"
When I tried to run it on a server, I get an error 76 (Path not found).
I really do not understand why as further up in my code, the following works fine both on Mac / PC as well as on server.
Code:
With Target
tr = ThisWorkbook.Path & Application.PathSeparator & .Offset(, -2).Value
MkDir tr
MkDir tr & Application.PathSeparator & "Name 1 folder"
MkDir tr & Application.PathSeparator & "Name 2 folder"
I am stumped on this one - any ideas?
Luke
PS: http://www.excelforum.com/excel-pro...aded-on-server-why.html?p=2879037#post2879037