Need help with Access/Project Automation

[drobinson]

'ello all,

Background:
I'm working on an automation project between MS Project 2000 and MS Access 2000 and was hoping someone could lend a hand.

One thing that I want to do is import a list of WBS task numbers from a Project .mpp file into Access. Periodically, a .mpp file will be used to update the WBS task list in the MC Access database, and it may be done by several users.

Looking for...:
I was curious if anyone knows of a way to identify, programmatically, the save version of a particular .mpp file. The reason why, is that a problem may occur if someone uses an outdated version of the .mpp to overwrite an existing set of WBS task numbers already in the Access database.

So, a couple questions then:

1. Does anyone know if a .mpp file stores some sort of save count property for the file? I'm sure it's in the header of the file, but am not sure yet what exactly it is.

If not..

2. Does anyone know how to retrieve the save date/time of an .mpp file programmatically using VBA? Can't find anything that would work on properly list from Microsoft that would work (at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pjsdk/html/pjprowbs_HV45318153.asp )

Any help would be appreciated.

Thanks!

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

VBA has the FileDateTime() function that will return the date and time a file was created or last modified.

FileDateTime("pathname")

The Scripting.FileSystemObject is a powerful tool when working with files. Search around if you need more info.

 

[drobinson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

VBA has the FileDateTime() function that will return the date and time a file was created or last modified.

Thanks for the help! These bits of information are just what I needed..the FileDateTime() function and to remember that when in doubt, go back to the basics! I searched other places, just not here, how's that for short-sightedness? I'm taking a note to give the Search option a good try from now on. Thanks again for the help!