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