Ditutup

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?

Kemahiran: Excel

Lihat lebih lanjut: project excel, import project excel, import mpp excel, import data project excel, import msp excel, import microsoft project excel, import project plan excel, excel vba import msp, vba excel import msproject, project milestone report, project vba import excel, importing project excel, project files excel, import project data excel, import data excel project, import excel project, macros project excel, excel import project vba, working from, unique background, highlight rag status msp, project plan export excel, milestones report project excel, project error report import, import projects excel

Tentang Majikan:
( 6 ulasan ) Birmingham, United Kingdom

ID Projek: #354554

12 pekerja bebas membida secara purata $81 untuk pekerjaan ini

piyushdpatel

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)
2.7
Nahian000

I am a student and can perform your work comprehensively.

$100 USD dalam 7 hari
(0 Ulasan)
0.0
priyankaroyagar1

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)
0.0
pdejan

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)
0.0
manishintas

Hello, Let`s start.Thanks,

$50 USD dalam 7 hari
(0 Ulasan)
0.0
jamiraisha

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)
0.0
chaekhar

I am interested to do this job especially in excel.

$50 USD dalam 6 hari
(1 Ulasan)
0.0
zoxno6

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

$80 USD dalam 2 hari
(0 Ulasan)
0.0
Tiybhu

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)
0.0
alliaunce

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)
0.0
rukkajju

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

$60 USD dalam sehari
(0 Ulasan)
0.0
sandy1984

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

$100 USD dalam 5 hari
(0 Ulasan)
0.0