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


--
achidsey

[Tom Ogilvy]

Sub Macro1()

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

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

End Sub

--
Regards,
Tom Ogilvy


"achidsey" <[email protected](notmorespam)> wrote in message
news:[email protected]...
> 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

[achidsey]

Tom,

Thanks as always.

Alan

--
achidsey


"Tom Ogilvy" wrote:

> Sub Macro1()
>
> FN1 = "C:\ACDocs\First\pa.txt"
>
> FileCopy FN1, "C:\ACDocs\Second\portfolio.txt"
>
> End Sub
>
> --
> Regards,
> Tom Ogilvy
>
>
> "achidsey" <[email protected](notmorespam)> wrote in message
> news:[email protected]...
> > 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
>
>
>