Getting Data into Ms Word

Topic

New Reply

Please ii need help in reading data from an Ms Project closed file into my word document, please any ideas

Reply | Quote

Replies

I assume you are trying to do this with VBA. If so, this thread should be moved to the VBA forum.

Can you tell us more about what you need to do? What data specifically do you need to extract from the Project file? Do you want it as a table in Word?

Reply | Quote

Cross-posted at: http://www.vbaexpress.com/forum/showthread/?t=44461
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Hi Andrew,

I would like to read out data the ProjectStartDate, ProjectFinishDate, And other task information like the task, TaskStartDate, TaskFinishDate, PercentageComplete etc all in a table, thanks.

Macropod, That was an omission error on my path.

http://www.excelfox.com/forum/f5/provider-cannot-found-may-not-properly-installed-645/#post2830

http://www.mrexcel.com/forum/excel-q…ml#post3322679

http://www.vbaexpress.com/forum/showthread/?t=44461

Reply | Quote

Hometech

The code that was posted on the ExcelFox forum works fine on my machine so I’m not sure on where the problem might be on your machine. I didn’t need to add any references at all to get the code to work although I changed the version number in the connection string because I am using Project 2003.

Reply | Quote

Well from research, i found that the OLEDB function is no longer supported in later versions of MS Project after 2003, i use project 2007.
I already found a way round it though and my code works fine. Thanks for the help.
Much appreciated.

Reply | Quote

Got another way around it @

http://www.vbaexpress.com/forum/showthread/?t=44461

Reply | Quote