Closed

[url removed, login to view] xml format from an excel file - repost

I am using [url removed, login to view] to upload customer info and print shipping labels. All our customer information is in an excel file. [url removed, login to view] 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 [url removed, login to view] xml format, which can be uploaded into [url removed, login to view] 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: Excel, XML

See more: stamps uploading xml, direct file upload, excel xml, what is macro in excel, xml export, xml excel, Visual Basic Excel, macro to upload, export from excel, excel visual basic, excel function, xml invoice, xml excel format, batch batch excel file, 2013 excel visual basic, excel 2013 visual, excel 2013 macro, xml file excel, excel macro upload data, visual basic 2013, visual basic excel 2013, visual basic shipping, excel xml list lists export, use print invoice, excel 2013 visual basic

About the Employer:
( 0 reviews ) United States

Project ID: #4324293

6 freelancers are bidding on average $131 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD in 5 days
(57 Reviews)
6.3
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$198 USD in 5 days
(25 Reviews)
5.8
mrbrave

I have great experience in developing macros for XML...See message box for working sample for excel 2003.

$120 USD in 2 days
(61 Reviews)
5.2
slavisatosic

Hello, I am offering you to make this export to XML using Excel VBA macro. Please see private message for details.

$100 USD in 2 days
(32 Reviews)
4.7
oggimbix

Hi, I've read your project description. I'll do expert coding for you on time. Please check my profile/portfolio and your PMB. Thanks.

$99 USD in 2 days
(1 Review)
0.3
amitchaps

[url removed, login to view] in excel/vba. Please check PM.

$70 USD in 2 days
(0 Reviews)
0.0