October 1998
Intermediate to advanced
656 pages
16h 10m
English
Content preview from VB & VBA in a Nutshell: The Language
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
| Name Statement |
Syntax
Name oldpathname As newpathname
oldpathname
Use: Required
Data Type: String
The current filename and optional path.
newpathname
Use: Required
Data Type: String
The new filename and optional path.
Description
Renames a disk file or folder.
Rules at a Glance
newpathname must not already exist or an error is generated.
newpathname and oldpathname can't be on different drives.
Path information included in newpathname and oldpathname can take the form of the local system's path or the UNC path.
newpathname and oldpathname can't include the wildcard characters ? and *.
You can't use the Name statement with a file that is already open.
Programming Tips and Gotchas
The Name statement can move a file from one folder to another, and optionally, can change the file's name at the same time. If the folder specified in newnamepath exists and is different from that stated in oldnamepath, the file is moved to the folder specified in newnamepath. If the filename in newnamepath is also different, the file is renamed at the same time. Moving an object in this way, however, only works with files; you can't use the Name statement to move folders.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.