Copy File without opening

[achidsey]

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

 

[Tom Ogilvy]

Sub Macro1()

FN1 = "C:\ACDocs\First\pa.txt"

FileCopy FN1, "C:\ACDocs\Second\portfolio.txt"

End Sub

 

[achidsey]

Tom,

Thanks as always.

Alan

--
achidsey

Sub Macro1()

FN1 = "C:\ACDocs\First\pa.txt"

FileCopy FN1, "C:\ACDocs\Second\portfolio.txt"

End Sub