export data code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi can someone give me an example of code to export some data to MS-Project.

Ive made a database to make choice and send this choice in a new project.
The database are ok, but Im not able to send these data to ms-project. It
must be easy for the user then I dont want to ask them to inport via
ms-project.

If someone can help me, it would be greatly appreciate

Thanks for help
 
You will have to establish a reference to the Project library you need.
There are about 6 or 7 depending on your versions of Access and Project.
Then you will have to become familiar with the Project Object Model and use
VBA code to create the object you need in Project.
 
I have the version 2003 for access and project.

I know that I have to create project object in my code, but I dont know how
to sentence the code to export my data to the ms-project files.

I never use code to export data before than its like mist for me.

Someone help me please, just an example of code and I will be able to do the
rest.

Thanks
 
Never having interfaced Access with Project, I don't have any code that would
help. I would suggest finding a book that shows how to use VBA in Project
and exploring the Project Object model in VBA help. You also might try
postin in the Project group to see if anyone there has done this and can help.

Good Luck.
 
Back
Top