Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileName
Is there a way to rename a file, any file, on my C: drive with this property
in Excel VBA? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileName
To rename a closed file
(it must be closed) oldfile = "C:\My Files\Myfile.txt" newfile = "C:\My Files\MyNewFile.txt" name oldfile as newfile -- Regards, Tom Ogilvy "Spencer Hutton" wrote in message ... Is there a way to rename a file, any file, on my C: drive with this property in Excel VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileName
VBA help:
Name Statement Renames a disk file, directory, or folder. Syntax Name oldpathname As newpathname The Name statement syntax has these parts: Part Description oldpathname Required. String expression that specifies the existing file name and location — may include directory or folder, and drive. newpathname Required. String expression that specifies the new file name and location — may include directory or folder, and drive. The file name specified by newpathname can't already exist. Remarks The Name statement renames a file and moves it to a different directory or folder, if necessary. Name can move a file across drives, but it can only rename an existing directory or folder when both newpathname and oldpathname are located on the same drive. Name cannot create a new file, directory, or folder. Using Name on an open file produces an error. You must close an open file before renaming it. Name arguments cannot include multiple-character (*) and single-character (?) wildcards. Spencer Hutton wrote: Is there a way to rename a file, any file, on my C: drive with this property in Excel VBA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
+ in filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Saving filename same as import filename | Excel Programming | |||
how to specify the filename | Excel Programming |