[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


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


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list