Copy File without opening
Excel Experts,
Without opening the file, I want to copy a text file in one directory to
another directory and save it with a different name.
Specifically, I have a file C:\ACDocs\First\pa.txt"
and without opening, I want to save it as C:\ACDocs\Second\portfolio.txt"
I tried the below code but I an "Object Required" errror on the SaveCopyAs
line.
Sub Macro1()
FN1 = "C:\ACDocs\First\pa.txt"
FN1.SaveCopyAs "C:\ACDocs\Second\portfolio.txt"
End Sub
What code would work?
Thanks in advance,
Alan
--
achidsey
|