+ Reply to Thread
Results 1 to 2 of 2

copy excel data to ms project fields

  1. #1
    Forum Contributor
    Join Date
    06-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    102

    copy excel data to ms project fields

    Anyone worked with writing a macro in excel where you can use the data in your excel file to copy data to microsoft project.

    I have an excel file of task name, deadline, time remaining, and assigned to and I want to copy those 4 columns to a correlating column in project. So basically I would loop through these fields on each line til I reach a blank which could be entering a varied amount of tasks.

    The full macro would change ms project start date to today's date then copy the 4 columns from excel to project to add a new task for each line in my file and then save the project file.

    Anyone have any reference or knowledge on this or anywhere for me to start? I've seen some links on macro with project but most are more advanced then this or are exporting data from project to excel.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    06-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: copy excel data to ms project fields

    I also meant to add that I have a ms project template with the same column names.

+ 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. Help stuck on project to populate multiple fields
    By jhill202 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2012, 09:53 AM
  2. Copy information from Excel to MS Project
    By ossa in forum Excel General
    Replies: 0
    Last Post: 07-04-2012, 08:21 AM
  3. Copy Excel data to Word fields and retain fields
    By GCW esq in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2012, 10:31 AM
  4. Office project:DATABASE DATA COPY FROM ONE TO ANOTHER
    By hattisaeed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2011, 08:32 AM
  5. Replies: 1
    Last Post: 10-18-2005, 11:05 AM

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