Shell to Project from MS Access using VBA

[trevorjhughes]

Hello All

I hope that some-one can help me.

I have an access database. I want to shell to Project and open the
mdb file from Project using a field map. I can currently open the mdb
file from Project using a predefined map but want to automate the
process from Access to simplify it for the users.

Does anyone know code which would enable me to shell to project and
open a mdb file using the map I have set up.

Any help would be appreciated

Regards
Trevor

 

[Rob Schneider]

Hello All

I hope that some-one can help me.

I have an access database. I want to shell to Project and open the
mdb file from Project using a field map. I can currently open the mdb
file from Project using a predefined map but want to automate the
process from Access to simplify it for the users.

Does anyone know code which would enable me to shell to project and
open a mdb file using the map I have set up.

Any help would be appreciated

Regards
Trevor

the book "VBA Programming for Microsoft Office Project" covers the
basics of this sort of thing. To get help from a newsgroup, ty the more
specific microsoft.public.project.developer where the VBA gurus hang out.