PS 2007 batch rename or batch delete via VBA macro?

[anovak]

Is it possible to use VBA to run through a list of projects for batch
rename or delete?

Thanks
Andy Novak
UNT

 

[Jack Dahlgren]

Certainly.
You can write code to get a list of projects on the server, but the easier
way if you are just doing this once in a while is to get a list of the
projects from Project Center (save to Excel) then use VBA to open the list
and read through it line by line. You could have a column for the new name
if you wanted.

Don't forget to check if the file is open read-only - this happens if
someone has the file checked out. I add a column on the excel file to
indicate whether the file was processed or not so I can go back later.

Also set displayalerts = False or you get all sorts of popup messages and
can't run it unattended.

-Jack Dahlgren

 

[andy.novak]

Certainly.
You can write code to get a list of projects on the server, but the easier
way if you are just doing this once in a while is to get a list of the
projects from Project Center (save to Excel) then use VBA to open the list
and read through it line by line. You could have a  column for the new name
if you wanted.

Don't forget to check if the file is open read-only - this happens if
someone has the file checked out. I add a column on the excel file to
indicate whether the file was processed or not so I can go back later.

Also set displayalerts = False or you get all sorts of popup messages and
can't run it unattended.

-Jack Dahlgren

Could you share what the VBA commands are for the rename and delete?

 

[alavinsky]

There is a Project Renamer tool. I've used it with some measure of
success.

http://code.msdn.microsoft.com/PS2007Rename/Release/ProjectReleases.aspx?ReleaseId=2028