Shell to Project from MS Access using VBA

T

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
 
R

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
Click to expand...

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.
 
Top