Dear Experts,

I really need your help. I work in a warehouse, the company wants to introduce kanban for material ordering, but I can't touch the warehouse management system. I already created a live table with ODBC which collects the required data, but I have problems with writing vba code which will export it to xml.

I checked many existing codes written by others, but none fits my needs or working perfectly.

So, there is 2 sheet in the excel file, "data" and "summary", I would like to export range A1:D3 from "summary" table and save it in every hour with the same name in the predefined directory (newest data should overwrite the older). Top row contains the header.


ITMCOD ITMDSC INVUOM QUANTY
98969106 name1 KG 73260
96874125 name2 KG 34410

The supplier would check this file via sftp and send stuff if we need.

Please help

Regards
Lazlow