Đã Đóng

MS Project to Excel macro

We require information from a number of Microsoft Project files to be merged into an Excel spreadsheet and displayed as per the example attached by use of a macro in Excel. It is important that the user just presses the macro button and all the information in the sheet is built automatically.

The number of projects will vary, but they will always be held in 1 MS Project file (see attached example).

In Excel coloured blocks are used to represent the different Project resources and the dates those resources are in use. No resource will ever overlap in time in a project.

The key to resource mapping between Project and Excel is;

client - Client approval

author - Author approval

writer - Writing

editor - Editing

studio - Studio

produtction - Production

all other resources - Third party approval

The project description in Excel is read from the MS Project file.

Each Project file task has the previous task as its predecessor.

The macro should ask the user the date range they wish to build the view for (default – 3 months)

Kỹ năng: Visual Basic, Màn hình Windows

Xem thêm: project excel macro, writing studio, writing dates, we excel, the writing studio, range resources, production spreadsheet, microsoft excel spreadsheet, has attached, excel &, author it, ask excel, excel project predecessor macro, export project predecessors, visual studio excel, n excel, ms visual studio, microsoft macro, author-it, WIsh, task number 1 project, spreadsheet microsoft excel, project, project writing, project c++

Về Bên Thuê:
( 0 nhận xét ) London, United Kingdom

Mã Dự Án: #20906

14 freelancer đang chào giá trung bình $837 cho công việc này

Spin

We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. There are questions?

$836 USD trong 20 ngày
(1 Đánh Giá)
5.9
encodedart

Please view PM. Thank you. EncodedArt Inc

$600 USD trong 15 ngày
(2 Đánh Giá)
4.8
Francena

Dear Prospect, We just completed a project that involves programming excel macros for Stock analysis today. We can start your project on 6th July 2005. Please contact us asap Warm regards Francena

$789 USD trong 20 ngày
(1 Đánh Giá)
4.6
mlgrow

Hi, I'm a software engineer with over 8 years of experience developing applications in the Microsoft environment. I have written a lot of vb script and vba macros. I only have a couple of questions regards this applic Thêm

$850 USD trong 30 ngày
(1 Đánh Giá)
4.4
inavigator

We can do that

$1000 USD trong 25 ngày
(2 Đánh Giá)
6.2
ItrixInc

Dear Sir/Madam, Thank you for providing me a oppurtunity to post my proposal for the MS Project to Excel macro. While going through your project we came to know that you are looking for a proffessional developer Thêm

$800 USD trong 25 ngày
(4 Đánh Giá)
3.7
tanuj99

pl see pmb for details

$986 USD trong 17 ngày
(1 Đánh Giá)
3.0
Spreadsh33t

Dear Occeurope, My name is Patrick Staring and I have over 10 years of experience in creating Office macro's for businesses. I can make an Excel macro for you that makes your report with the data from MS project. Pleas Thêm

$650 USD trong 7 ngày
(2 Đánh Giá)
2.2
ebusiness2

Our bid is for really very high quality work for your MS Project to Excel macro that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes si Thêm

$1000 USD trong 30 ngày
(1 Đánh Giá)
3.0
XLLance

Please check PBM

$700 USD trong 20 ngày
(0 Đánh Giá)
0.0
WebIntegrated400

do not sacrifice quality for cheap promises. lets get started. thanks.

$1000 USD trong 20 ngày
(0 Đánh Giá)
0.0
Webcare

WebCare’s management team is characterized by a uniquely strong combination of knowledge and experience. WebCare’s team members have vast global experience and proven track records with companies. Our Industry-certifie Thêm

$900 USD trong 20 ngày
(0 Đánh Giá)
0.0
TECHZONE1

Hello There, You have already recd. many bids and I would be lucky if you read and consider mine. I have just joined this site today and this is the second project I am bidding for. I have over 7+ yrs of s/w experience Thêm

$900 USD trong 20 ngày
(0 Đánh Giá)
0.0
ravisbox

The work can be completed in the stipulated time provided you send me the data properly zipped with complete requirements in a text file. You can make payment by cheque, IPO after trial. I trust you. Any further modifi Thêm

$700 USD trong 90 ngày
(0 Đánh Giá)
0.0