The VBA code should reside in MS Project.
There should be a separate tab in MS Project with 2 menu items
1. Extract data to excel file
2. Update MS Project file from Excel FIle
[url removed, login to view] data to excel file >>Extract Resource wise tasks to multiple excel files and save on a folder with file names having resource name and date time stamped.
This excel Extract will have task details from Ms project , the excel file will have Unique ID, Resource Name, Task Name, Start Date,Finish Date & Percentage Complete.
The User will change the start date, finish date or percentage complete on the excel file and save it.
[url removed, login to view] MS Project file from Excel FIle >>On Ms Project(MSP) when user clicks update data option ,There should be a open dialog box to select the updated excelfile and once selected ;
a) read data from the excel file and locate the correct task row on ms project based on the Unique ID field on the excelfile
b) Once Located, if excel file finish date > MSP finish date, then increase the MSP duration field to match the finish date.
** Also needs to validate if the date falls on a holiday based on the MS Project Calender then change the date to the next following work day.
If excel file Start date > MSP start date and excel Percentage complete>0 then update the start date without putting any constraints ( update the actual start date)
While updating any dates , it should not put any constraints other tham ASAP to the task and should be auto scheduled with "as soon as possible constraint"
If [url removed, login to view] complete <> MSP percentage complete the update MSP file as per excel file.
** Also before the update process starts need to validate and check whether the excel file is a valid file and show the no of records to be update
While updating the data if there is an error or invalid data need to show error details to the user.
If successfully completed show the no of records updated
12 freelancers are bidding on average $208 for this job
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
With 5+ years of experience in VBA and automation i feel i could accomplish this. Also i did several Workflow VBA Application for my earlier companies which they are still using.