Project VBA - Open each file in a folder and make a change to each

[mab9]

We have a series of 250+ MS Project files that were built off of a certain template. Now there is a need to make changes to the templates & all the 250+ existing files that are out there. Rather than having to open every file and do it manually, is there a VB script that will:

- Open all MS Project files in a certain folder one by one
- As each file opens, write certain changes
- Save changes to current file
- Close current file
- Open next file & repeat until all have been updated

[Pugsly]

I've written this many many times. Look up the help for the VBA.Dir function, it has an example and all.

[Ghadush]

I have same issue and couldn't locate the sample macro Jan mentioned

[Pugsly]

In order to access each mpp file in a folder use the following

Anaddress=vba.dir(folderaddress\*.mpp)

While not on len make it (anaddress)=0