A
Adriano Labate
Hi,
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 ?
Thanks.
Adriano
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 ?
Thanks.
Adriano