| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Used to be possible in Excel97
Hi.
Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Used to be possible in Excel97
Albert,
Name "OldFile" As "NewFile" NickHK "Albert" wrote in message ... Hi. Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Used to be possible in Excel97
I don't get it.
"NickHK" wrote: Albert, Name "OldFile" As "NewFile" NickHK "Albert" wrote in message ... Hi. Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Used to be possible in Excel97
The command looks like this:
Name strOldFilename As strNewFilename where strOldFilename and strNewFilename are string variables containing the old and new filenames. Or just use the text: Name "c:\temp\oldname.xls" As "c:\temp\newname.xls" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Albert" wrote in message ... I don't get it. "NickHK" wrote: Albert, Name "OldFile" As "NewFile" NickHK "Albert" wrote in message ... Hi. Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Used to be possible in Excel97
That's the code to use . Check the help for the Name statement.
Name "C:\Oldfile.txt" As "C:\NewFile.txt" NickHK "Albert" wrote in message ... I don't get it. "NickHK" wrote: Albert, Name "OldFile" As "NewFile" NickHK "Albert" wrote in message ... Hi. Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Used to be possible in Excel97
Got it, did it.
Thanks. "Jon Peltier" wrote: The command looks like this: Name strOldFilename As strNewFilename where strOldFilename and strNewFilename are string variables containing the old and new filenames. Or just use the text: Name "c:\temp\oldname.xls" As "c:\temp\newname.xls" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Albert" wrote in message ... I don't get it. "NickHK" wrote: Albert, Name "OldFile" As "NewFile" NickHK "Albert" wrote in message ... Hi. Is there any way of renaming files through VBA with Excel XP? I remember it used to be possible with previous versions. Best regards, Albert C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel97 not quit | Excel Programming | |||
| Excel97 vs Excel2000 | Excel Programming | |||
| Using Outlook98 with Excel97 | Excel Programming | |||
| Help with Excel97 formatting | Excel Programming | |||
| Help with Excel97 formatting | Excel Programming | |||
Linear Mode
