List all MPP files in Folder

[Gina Liddle]

I need to save all MPP files under a specific folder to an Access Database.
How do I obtain a list of the files so to open and save each one by one?

Thanks in advance.

G

 

[Jan De Messemaeker]

Hi Gina,

You have to use the VBA.Dir statement.
It is fully explained in the help (use once with the folder and \*.mpp, then
loop with just the empty Dir statement till the response is zero-length).
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Gary Johnson]

Hi Gina,

Is there any reason why you shouldn't be saving all your projects direct to
an Access Database in the first place ?

Regards

Gary