Encerrado

VBA scheduling macros for Ms Project 2010 to update dates from excel file

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

Habilidades: Excel, Agendamento de Projeto, Visual Basic para Apps

Ver mais: visual basic for applications, vba time, vba open folder, vba error, vba and macros, VBA Macros, vba code excel, VBA and excel, validate excel, save to excel, Project Scheduling , project on vba, ms project, invalid project id, change project duration, extract data excel file, vba update excel, project file, save excel read, need match files excel, update vba code vba, file menu save, vba tasks, update dates, check excel files

Acerca do Empregador:
( 0 comentários ) Australia

ID do Projeto: #6829148

12 freelancers estão ofertando em média $208 para este trabalho

mantislin

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

$250 AUD in 5 dias
(42 Comentários)
5.7
tomislav1975

I have some experience in such tasks and can do this. Contact me if interested. Thanks, Tom____________________________________

$333 AUD in 7 dias
(17 Comentários)
4.4
igotmail9

Dear Sponsor, I am a hard core developer with 14 years of experience in software development with Java (3Y), C++ (10Y), C#(3Y), Visual Basic, Excel, VBA programming, Web programming, HTML5, PHP, MySQL, Linux and Win Mais

$221 AUD in 5 dias
(6 Comentários)
3.8
Mufaddalsaifee

Hi, Thanks for posting this project. I will write a Macro which pull data and store into excel. Kindly message me so that we further discuss. I have 3+ years of experience in VBA coding and VB.net. i have rece Mais

$155 AUD in 3 dias
(15 Comentários)
3.6
ayanbishnu

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in [url removed, login to view] IF you need see some samples of my work, then, pleas Mais

$315 AUD in 8 dias
(5 Comentários)
3.4
abhinovpankaj

Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio Mais

$155 AUD in 3 dias
(5 Comentários)
3.2
JeffLee21

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. You can found good my projects in my work history. I think that I can provide to y Mais

$263 AUD in 3 dias
(2 Comentários)
3.2
clearatul0

I have 4 years experience in VBA Macro, I have already worked with Whirlpool USA with an automated analytic tool and I am currently working on big energy project from Poland. Regarding your project, I can write th Mais

$155 AUD in 7 dias
(1 Comentário)
2.5
amr2007

A proposal has not yet been provided

$200 AUD in 2 dias
(0 Comentários)
0.0
Asifibnenizam

A proposal has not yet been provided

$155 AUD in 3 dias
(0 Comentários)
0.0
bs4y1964

Dear Ladys, dear Gentleman, We would like to submit you an offer for your project. Despite more than 25 years of market presence, we are here on this web portal one of the 'young' provider. We would like to introdu Mais

$210 AUD in 3 dias
(0 Comentários)
0.0
saianupkumarp9

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.

$88 AUD in 3 dias
(0 Comentários)
0.0