Import From MS Project into Excel

Some time a go I wrote a macro that populates MS Project data into an Excel workbook (a weekly Project Highlight Report), I haven't created anything similar for a while now and have forgotten how to do it. With this in mind I'm looking for the following:

1) An "Import Milestone Data" button is to be created in an excel workbook.

2) Selecting the button opens a pop-up that's asks you to navigate to a MS Project plan (my documents should be the default location).

3) The script should then delete all previous values held in the table.

4) The VBA macro then imports the following MS Project data and places it in row 6 (row A1 = "Milestone Report", row 2 = Blank, row 3 = The button should go here, row 4 = Blank, row 5 = Headings):

Column A - Unique ID (standard MSP column)

Column B - Name (standard MSP column)

Column C - Owner (customised field, this is actually "Text 5")

Column D - RAG Status (customised field, this is actually "Text 6")

Column E - Baseline Finish (standard MSP column)

Column F - Previous Finish (customised field, this is actually "Finish 1")

Column G - Finish (standard MSP column)

Column H - % complete (standard MSP column)

Column I - Notes (standard MSP column)

The data imported needs to have the following filter applied to it:

Flag 5 = "Yes"

No summary information should be imported.

Column D contains "R", "A", "G" values. The "R" values need to have a red fill/background colour, "A" needs to be amber/orange and "G" needs to be green.

I've attached a template which also contains some code that I can't getting working properly.

I think that's it, relatively simple and should only take a short time to sort out... what can you do?

Update - the following column now needs including between columns D (RAG Status) and E (Baseline Date):

"Previous RAG Status" (customised field, this is actually text7).

I've attached an update template to reflect the change.

If you can get this back to me within 24 hours the job is yours!

Kemahiran: Excel

Lihat lagi: project excel, import project excel, import mpp excel, import data project excel, import msp excel, import microsoft project excel, import microsoft project data excel, import project plan excel, msofiledialogfilepickerms project, excel vba import msp, vba excel import msproject, project vba project import, project milestone report, project vba import excel, importing project excel, project files excel, import project data excel, import project data excel using vba, import data excel project, import excel project, macros project excel, excel import project vba, working from, what is ms project plan, unique background

Tentang Majikan:
( 6 ulasan ) Birmingham, United Kingdom

ID Projek: #354554

12 pekerja bebas membida secara purata $81 untuk pekerjaan ini


Hi This is Piyush Patel I have 4 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6. I have done Import Export File in Excel Please Check my PM

$50 USD dalam 2 hari
(3 Ulasan)

I am a student and can perform your work comprehensively.

$100 USD dalam 7 hari
(0 Ulasan)

hello. i have understood your requirements clearly n assure you that it wil be done accurately. looking forward for your response regards

$50 USD dalam 2 hari
(0 Ulasan)

Hi, I am very interested in your offer and would provide you with good service. Although I am new to GetAFreeLancer, I have extensive experience in this field. Please provide the details of your exact requirements.

$49 USD dalam 2 hari
(0 Ulasan)

Hello, Let`s [login to view URL],

$50 USD dalam 7 hari
(0 Ulasan)

Hello. i have understood your requirements clearly n assure you that it wil be done accurately. looking forward for your response regards

$100 USD dalam 5 hari
(0 Ulasan)

I am interested to do this job especially in excel.

$50 USD dalam 6 hari
(1 Ulasan)

Respected cmcmonagle, In your VBA script you call user defined function named [login to view URL] function is similar as GetFileOpen [login to view URL] is File open dialog box. You have error in next line 'Create a Fi Lagi

$80 USD dalam 2 hari
(0 Ulasan)

Hi i working in Caretel Infotech Ltd Company from last 2 years and i have lot of experiance in this work. Dont worry I will do your work as your requrement.

$80 USD dalam 4 hari
(0 Ulasan)

I have done similar project for another project management tool (DotProject). I can customise the same for MSProject.

$200 USD dalam 7 hari
(0 Ulasan)

hi there, WE can negotiate....thanks syed

$60 USD dalam sehari
(0 Ulasan)

hai pls give me this project i will finish it quckly and without any mistakes

$100 USD dalam 5 hari
(0 Ulasan)