In Progress

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.

Skills: Visual Basic, XML

See more: 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, vba create file, xml vba, excel create xml vba, create xml xls vba, create xml file using vba

About the Employer:
( 5 reviews ) Adelaide, Australia

Project ID: #123920

Awarded to:

vosmerkin

Please, check pmb

$100 USD in 0 days
(2 Reviews)
3.2

15 freelancers are bidding on average $167 for this job

xamdam91

Looking forward to working with you

$250 USD in 1 day
(55 Reviews)
6.1
schandraram

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

$225 USD in 10 days
(56 Reviews)
6.0
saamorim

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

$150 USD in 10 days
(9 Reviews)
4.8
momleetech

We can do it

$200 USD in 10 days
(14 Reviews)
4.8
MustafaSR

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

$150 USD in 1 day
(14 Reviews)
3.9
siracus

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

$200 USD in 9 days
(0 Reviews)
0.0
pk86la

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

$185 USD in 10 days
(0 Reviews)
0.0
jtillis

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

$200 USD in 10 days
(0 Reviews)
0.0
zhangch1020

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

$150 USD in 10 days
(0 Reviews)
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

$200 USD in 10 days
(0 Reviews)
0.0
ripanarya

I can do this. Please check your PM

$100 USD in 10 days
(0 Reviews)
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

$100 USD in 10 days
(0 Reviews)
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.

$200 USD in 5 days
(0 Reviews)
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 More

$100 USD in 2 days
(0 Reviews)
0.0