• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

The ImportProject Macro

Let's say you have an Excel spreadsheet full of data and you want to build a plan from it. This is a common problem for Project VBA developers. Solving it will introduce you to controlling Excel from within Project, creating links between tasks, indenting them to create summary tasks, and then assigning resources. A typical occurrence is a basic list of tasks for a project created by mainframe production or enterprise control software that can be exported to Excel. The next problem you face is getting that data into Project.

For this macro to work, you will need Excel 97 or 2000 actively running with a spreadsheet having the following columns: Task ID, Task Name, Duration in Days, Outline Level, Predecessor, Resource Name, and Work in Hours. (Open "Chap28/Project Information.xls" for an example.) These are the basic building blocks for the ImportProject macro:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint