Terminé

Excel VBA (create custom XML file)

An experienced Excel VBA programmer is required (Excel 2003) to create a VBA script that can extract data from an Excel spreadsheet and create custom XML files. The XML files are used to populate a web-based graphing application (the graphing application has already been developed).

The graphing application is located at:

[url removed, login to view]

The general specification for the data files can be found in [url removed, login to view]

The XML format has been modified slightly to allow for more than two years of data, and for the colour of each year to be specified in the XML file.

Copies of the existing XML files are contained in the [url removed, login to view] archive. Updated xml files reflecting the changes in the previous paragraph will be supplied prior to the commencement of the job.

You should note that the number of years, areas, targets or objectives may vary. Thus your VBA code should be able to search through the spreadsheet and automatically determine how many of each exist and create a compliant xml file.

Compliance of the xml file will be tested against the graphing application (ie the xml file must be fit for our purpose).

Sample data in contained in the file [url removed, login to view], however the layout may change slighlty. Your code needs to be smart enough to determine the relative position of data rather than the absolute (fixed) position. Only the percentage columns are used in the data files. You also need the labels and other properties as described in xmlData.doc.

Your code should use good coding standards and be well documented.

If you do a good job then there may be an additional project.

Compétences : Visual Basic, XML

en voir plus : vba create xml file, create xml file vba, excel vba create xml file, create xml file excel vba, vba create xml, create xml vba, excel vba xml, excel vba create xml, vba xml, create xml excel vba, create xml vba excel, write xml vba, vba create xml file excel, create xml file vba excel, vba excel create xml file, vba excel xml, vba xml create, vba write xml file, create xml file excel, vba excel create xml

Concernant l'employeur :
( 5 commentaires ) Adelaide, Australia

Nº du projet : #123920

Décerné à:

vosmerkin

Please, check pmb

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(2 Commentaires)
3.2

15 freelance font une offre moyenne de $167 pour ce travail

xamdam91

Looking forward to working with you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(55 Commentaires)
6.1
schandraram

Hello Please see PMB for details of my bid. Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(56 Commentaires)
6.0
saamorim

Greetings! Please review your private messages for more detail information. Regards. Saamorim

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(9 Commentaires)
4.8
momleetech

We can do it

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(14 Commentaires)
4.8
MustafaSR

Hello, have gone through the detail and Ready to work at once.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.9
siracus

We can do this. Plx. check P.M.B for detail's. Regard's Cris

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 9 jours
(0 Commentaires)
0.0
pk86la

Hi! I'm very interested in your project. Ready to begin at once. Thank

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
jtillis

I would love to do this project. Please see my PWB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
zhangch1020

This is my first bid,i hope i can get it.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
blueangel6

I have experience in the area where you want help. I have 8 years as a programmer, so you won't be regret. I can start immediately. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
ripanarya

I can do this. Please check your PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
oesf

Hello, this is my first work in getafreelancer, but I'm a bank programmer with a lot of experience. Thanks for your time

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
mohsincse

I am newcomer for outsourcing work .But i have lot of experience for doing this type of work. So ,i need your help for doing this type of work .Thanking you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
nitinkjain

I have 3 years of experience and have been working on the similar requirements of our UK client. I work on VB and created lot many Excel Macros that are widely appreciated by my CMM Level5 company. I would love to serv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0