stamps.com xml format from an excel file - repost

CLOSED
Bids
6
Avg Bid (USD)
$131
Project Budget (USD)
$30 - $250

Project Description:
I am using stamps.com to upload customer info and print shipping labels. All our customer information is in an excel file. Stamps.com supports batch uploading using their own xml format. What we need is to automatically (or just press one button) export the excel data into the stamps.com xml format, which can be uploaded into stamps.com software directly.

The technical difficulties (for me) are :

1) the xml file needs to have data which is defined as "list of lists" by excel. List of lists is not exportable to xml by excel.

2) automatically generate the xml file from the excel file. This could be achieved by a macro or a visual basic button? I already have one "print invoices" button with the excel file, I like to append the new function of generating the xml file to it. So at the end, I only need to click one button, all invoice will be printed (current existing function) AND the ready-to-use xml file will be created (to be done).

Updates: I am using Excel 2003. I also uploaded the xml format I need, and the excel file. In the uploaded excel file, all cells contain direct values. However in the actual excel file (which is too big to upload), all values are calculated from formulas.

Thank you

Skills required:
Excel, XML
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: xmltestcode11.xml excel+file.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire bharanisrihari
$ 200
in 5 days
$ 198
in 5 days
Hire mrbrave
$ 120
in 2 days
Hire slavisatosic
$ 100
in 2 days
Hire oggimbix
$ 99
in 2 days
$ 70
in 2 days