Em Andamento

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.

Habilidades: Visual Basic, XML

Ver mais: 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

Acerca do Empregador:
( 5 comentários ) Adelaide, Australia

ID do Projeto: #123920

Premiar a:

vosmerkin

Please, check pmb

$100 USD em 0 dias
(2 Avaliações)
3.2

15 freelancers estão ofertando em média $167 para este trabalho

xamdam91

Looking forward to working with you

$250 USD em 1 dia
(55 Comentários)
6.1
schandraram

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

$225 USD in 10 dias
(56 Comentários)
6.0
saamorim

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

$150 USD in 10 dias
(9 Comentários)
4.8
momleetech

We can do it

$200 USD in 10 dias
(14 Comentários)
4.8
MustafaSR

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

$150 USD em 1 dia
(14 Comentários)
3.9
siracus

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

$200 USD in 9 dias
(0 Comentários)
0.0
pk86la

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

$185 USD in 10 dias
(0 Comentários)
0.0
jtillis

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

$200 USD in 10 dias
(0 Comentários)
0.0
zhangch1020

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

$150 USD in 10 dias
(0 Comentários)
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 dias
(0 Comentários)
0.0
ripanarya

I can do this. Please check your PM

$100 USD in 10 dias
(0 Comentários)
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 dias
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$100 USD in 2 dias
(0 Comentários)
0.0