[dba-Tech] Renaming Windows Folders using code

Hi Martin

It should be transferable to VbScript with little modification. Don't know about PowerShell.

/gustav


>>> mwp.reid at qub.ac.uk 20-05-2010 17:29 >>>
Thanks Gustav

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

Sorry for confusion.

Martin


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)

/gustav


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

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.

eg
mreid
rreid
ereid

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

first letter space then surname

Martin