Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to reconstruct the Microsoft Project Task information to Excel sheet by VBA?

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 20-04-2009
Member
 
Join Date: Apr 2009
Location: Korea
Posts: 1
blush How to reconstruct the Microsoft Project Task information to Excel sheet by VBA?
  

Hello.

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.

Reply With Quote
  #2  
Old 20-04-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
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):

Application.Projects
is the same as:
Projects

For more information on: How To Create an Excel Macro
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 03:30 AM.