Project VBA - Open each file in a folder and make a change to each
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
Re: Project VBA - Open each file in a folder and make a change to each
I've written this many many times. Look up the help for the VBA.Dir function, it has an example and all.
Re: Project VBA - Open each file in a folder and make a change to each
I have same issue and couldn't locate the sample macro Jan mentioned
Re: Project VBA - Open each file in a folder and make a change to each
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