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!
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
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.