Thread
:
backing up file in directory
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
backing up file in directory
Lance,
Use FileCopy to copy the file.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
wrote in message
...
The user is asked to select a file:
Dim SaveDriveDir As String
SaveDriveDir = CurDir
ChDrive "C"
ChDir "C:\NREP\REL"
OFILE = Application.GetOpenFilename("NREP Relative Power Files,*.rel",
1, "Select One File To Open", , False)
Now I want to copy the file with a new name because I am going to
overwrite the existing file OFILE
copy OFILE & ".org"
How do I do this?
Lance
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson