Hi,
I have a macro which saves files to other mapped network drives. Can anyone tell me if there is any reason for using one of the methods below rather than the other? Would one be quicker, more efficient, more reliable, etc? Thanks for any help
Method 1:
dim mp
.....
mp = "X"
file = "save this.xls"
Windows(file).Activate
ActiveWorkbook.SaveAs FileName:= mp & ":\" & file, FileFormat:=xlNormal
ActiveWorkbook.Close
Method 2:
dim mp
.....
mp = "X"
file = "save this.xls"
Windows(file).Activate
ActiveWorkbook.SaveAs FileName:= "C:\" & file, FileFormat:=xlNormal
ActiveWorkbook.Close
FileCopy "C:\" & file, mp & ":\" & file
And, would it make any difference if I was saving .csv files rather than .xls?
Cheers
free
Bookmarks