+ Reply to Thread
Results 1 to 2 of 2

An Excel tool for extracting a Microsoft Project file into Excel

  1. #1
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,875

    An Excel tool for extracting a Microsoft Project file into Excel

    The attached file is an Excel file that will open a Project file and extract the information into an Excel file. This is very helpful for providing a project to people who do not have Microsoft Project. Project does have the ability to export to Excel but it is not as comprehensive as this.

    This tool uses late binding; no references are required so should work

    The macros can be exported and imported into Microsoft Project. To run in Project, change all occurrences of
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    The output file can be edited but is intended primarily for information and analysis, rather than as a substitute for using Microsoft Project to maintain the project.

    Features:
    • Show Project flag values
    • Creates an Excel outline so you can view the desired task level
    • Allows selection of which fields to include
    • Automatically detects custom fields that have been given custom names and allow them to be selected for inclusion
    • Option to include a column to prompt the user that they have made a change to data that requires corresponding changes (e.g., change to 100% complete but finish date is in the future)


    Using:
    • Upon starting the process, you will be prompted to select a Microsoft Project file.
    • The tool opens Project and opens the file.
    • A form comes up that allows you to select the fields for export. The task name is always required. Built-in fields have a checkbox. Custom fields are shown in a listbox. All selected fields appear in a listbox to the right which can be sorted to indicate the order you want the columns in the Excel file.
    • You will see a progress bar for loading the task data
    • Then you will see a notice that formatting is occurring (not a progress bar)
    • The project data will be on the first worksheet and a legend on the second.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    02-07-2021
    Location
    Madrid
    MS-Off Ver
    office365
    Posts
    2

    Re: An Excel tool for extracting a Microsoft Project file into Excel

    Very interesting. I'll give a try!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. free tool to generate UML class diagram for Excel VBA project?
    By excel_joe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2016, 03:12 PM
  2. Can someone help in building a currency converter tool in Microsoft Excel 2013
    By shubh66 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2015, 09:54 AM
  3. Excel as Project Management Tool?
    By slord in forum Excel General
    Replies: 4
    Last Post: 05-23-2015, 02:46 PM
  4. [SOLVED] I'm having trouble with Microsoft Excel 2010 64 bit spreadsheet1 VBA macro tool
    By sgtduplechain in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-16-2012, 01:37 PM
  5. microsoft project and excel
    By chrismartinpetty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2010, 04:21 PM
  6. [SOLVED] How can I create a project estimation tool with excel
    By MAH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2006, 08:35 PM
  7. Microsoft Office Data Analyisis tool pack for excel
    By b5brooke in forum Excel General
    Replies: 0
    Last Post: 02-20-2006, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1