By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Linking Microsoft Project and Microsoft Access.

damonreid
Expert 100+
P: 114
Firstly is it possible to take values from Project and use it to populate fields in access and secondly if it is does anyone have a tutorial? I can't appear to find anything online other then.

http://www.projectperfect.com.au/info_msp_reports.php

which appears force you to take all fields. I would like to populate existing fields with parts of the output if possible.

Thanks,
Damon
Jul 20 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hey Damon

The only way I can think of doing this is with MS Project automation. I've never used it but the following should get you started. You will probably have to add a reference to the MS Project Library in your references list.

Expand|Select|Wrap|Line Numbers
  1. Dim ProjObj As MSProject.Application
  2.  
  3. Set ProjObj = CreateObject("msproject.application")
  4. ProjObj.FileOpen "path to folder" & GetFilename, _
  5.   ReadOnly:=False
  6.   ProjObj.Visible = True
  7.  
  8. Dim ActiveProject As MSProject.Project
  9. Set ActiveProject = ProjObj.ActiveProject
Jul 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.