Automation through Access of MS Project

[karassik]

I have created an Access 2000 database which I would like to have push information into a MS Project file then link that file to my Access hours table.

My problem is that I have no code that I can look over to try to decipher how I can do this. So does anyone have any code which uses Access 2000 to control MS Project 2000?

Also does anyone have a suggestion to go about this scenario in Automating Excel from Access:

I open an existing Excel file put some numbers into it from Access, then I need the user to utilize the numbers I have pushed in to type their own numbers in. I total the users numbers in Excel and as the user (Closes Excel or Presses a Transfer Button?) I want those totals to be pulled or pushed into fields in Access. My question is do I have to do this from Excel or can I check for the closing of that Excel file from Access to then pull the totals into Access?

Thanks,
Nishan Karassik

 

[gwinn7]

Your question is VERY broad. I would suggest checking out articles in Microsoft's TechNet CDs, Microsoft's Knowledge Base, or do searches on the Internet for sample code.

If you have a more specific question, I am sure one of us experts can help you better.

Gary
gwinn7
A+, Network+

 

[karassik]

How would you recommend dealing with my Excel issue? Can I run a check in the background while Excel is being manipulated then before the close of Excel, Access pulls the new data from Excel? Or do I have to acctuate it from Excel and push the data into Access?

Thanks,
Nishan

 

[scking]

Simply, from Excel you can do the following:

Using ADO,
1) Run a 'Stored Procedure' using a parameter. The stored procedure could update the tables.
2) Create a recordset from any select query or table and use the Edit,Update methods of ADO to change the data.
Using DAO,
Create a recordset from any select query or table and use the Edit,Update methods of DAO to change the data.

On the subject of MS Project,
You are correct that there is little or no documentation about using automation for MS Project. I have been learning this over the past 5-7 years. About 5 years ago you could get a copy of some documentation from Microsoft for free called, "Microsoft Project 98 Visual Basic Environment". It's about 500 pages and is really the only thing I have found. It was also published on their web site in electronic form and I no longer have that. My application creates a .MPX file which I subsequently open with MS Project. It proliferates files but saves a database state for access at any future time. There is a very large learning curve associated with the trial and error process of learning the MS Project object model through coding. Have fun.

Steve King Growth follows a healthy professional curiosity