|Tags: excel, microsoft project, vba|
| ||Thread Tools||Search this Thread|
How to reconstruct the Microsoft Project Task information to Excel sheet by VBA?
I'm making a macro to reconstruct the Microsoft Project Document.
and I'm trying with VBA to resave the tasks matters that I want to show.
So I want to save Excel sheet through Microsoft Project Macro.
How can I solve this problem.
Thank you in advance.
Re: How to reconstruct the Microsoft Project Task information to Excel sheet by VBA?
The first thing is in how to set the task. This is done using the Set keyword. Typically one sets a collection to all the tasks in the project, but it is possible to set it to some other task collection.
Here is an example of setting it to the tasks in the active project:
Dim ts as Tasks
Set ts = ActiveProject.Tasks
Using a Project object of some kind is essential to programming Project. Like the Task object, it is also a member of a collection, in this case it is part of the Projects collection. Although the Projects collection is under the Application it is what Microsoft calls a "top-level object" meaning that you can use it without needing to specify the Application. This means both of the following are equivalent within Project (though if you are controlling project from another application you will want to specify the application just to be clear):
is the same as:
For more information on: How To Create an Excel Macro
|Thread Tools||Search this Thread|
|Similar Threads for: "How to reconstruct the Microsoft Project Task information to Excel sheet by VBA?"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to view the link between the deliverable project task and the dependency project task in project pro 2010||Hevel||Microsoft Project||4||20-04-2012 11:22 PM|
|How to get rid of single quote in Microsoft Excel sheet||Wisaal||MS Office Support||2||10-02-2012 04:22 PM|
|Not able to edit a lock sheet in Microsoft Excel||Tur^turro||MS Office Support||3||25-01-2012 07:01 PM|
|How to recover a deleted sheet in Microsoft Excel 2007||Al Kaholic||MS Office Support||2||24-01-2012 06:44 PM|
|Exporting Project files in form of Excel Sheet||aelmalki||Microsoft Project||10||20-04-2011 07:49 PM|