Excel Developer Tab, Export XML, programmatic control of "Save As" options?

Question:

• How can one control Excel's XML export process?


• Are options, excluding save to file, available?

Big Picture, moving data from Excel XML table to ERP application.

Current solution:

Setup:

• Developer Tab is activated in end user's Excel


• Spreadsheet with XSD map pre-loaded and pre-mapped is provide to end user

User modifies data in Excel and performs data transfer by:

• [Developer Tab], [Export], [Export XML] (similar to Save-As dialog), specify file name, click [Export] button, data is exported to XML file


• User opens saved XML file via notepad (or any editor that does not "render" the xml), "select all", copy to clip board


• User opens a "paste dialog" box run by ERP application, pastes XML from clipboard, and submits to ERP for processing.

Better Solutions would include:

1. Save XML directly to clipboard


2. One Click Post XML directly to Webservice run by ERP


3. Any solution where non-technical users do not have to manipulate/handle files in the transfer process

For the sake of exploring options, lets assume the security requirements will be appropriately handled.

Thoughts or ideas? TIA