Opening Excel with template and XML imported file by command line


Adriano Labate


I would like to use Excel 2003 to show reports to the customer.
I have an Excel template (.xlt) for the presentation and a XML file
containing the data with also the XSD inline for the schema description.

How could I open Excel with the template *and* importing a XML file from the
command line (to be open from a Windows shortcut) ?

In the UI that's done manually by opening the template, then importing the
XML by selecting the Data menu > XML, and Import XML.

The command line options seems very rudimentary. Is there a way to do that
with a script or a macro, knowing that there's no direct link between the
template and the data XML file ?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question