[dba-Tech] Renaming Windows Folders using code

Martin Reid mwp.reid at qub.ac.uk
Thu May 20 10:29:26 CDT 2010

Thanks Gustav

Sorry I amnot being very clear. I have to do this out in Windows as opposed to Access!

Sorry for confusion.


Martin WP Reid
Information Services
The McClay Library
Queen's University of Belfast
10 College Park
Belfast BT7 1LP
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
Sharepoint Training Portal
From: dba-tech-bounces at databaseadvisors.com [dba-tech-bounces at databaseadvisors.com] On Behalf Of Gustav Brock [Gustav at cactus.dk]
Sent: 20 May 2010 16:04
To: dba-tech at databaseadvisors.com
Subject: Re: [dba-Tech] Renaming Windows Folders using code

Hi Martin

Try with

  Name "mreid" As "M Reid"

or rather:

  Name "d:\path\mreid" As "d:\path\M Reid"

The new name can be build this way:

  strNew = UCase(Left(strOld, 1)) & " " & StrConv(Mid(strOld, 2), vbProperCase)


>>> mwp.reid at qub.ac.uk 20-05-2010 16:32 >>>

I imported a load of SharePoint data from a backup and ended up with a folder structure based on site names which are first initial and surname.


I need to loop over that structure and change the folder name to m reid, r reid etc

first letter space then surname


dba-Tech mailing list
dba-Tech at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the dba-Tech mailing list