Excel Automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DimkaSPB - 18 Sep 2003 17:06 GMT

Hi,

I need to use Excel Automation to apply an excel template to an excel
document automatically.

Some background info... Basically my application exports an excel document.
Before, users used to open up this document in Excel and applied a template
to it. Everything was done manually. Now, I need to export a file, apply a
template automatically using excel automation and open up excel with my
formatted document.

Any help on using excel automation is appreciated.

Thank you,
Dmitry

Reply to this Message

Mark Scott [MSFT] - 31 Oct 2003 21:07 GMT

Dmitry,

Depending on what version of Excel you are using, you may find it easier for
your application to save a raw XML file. You could then apply XSLT templates
programmatically to convert XML into an Excel file based on the Excel XML
schema.You may also find this link helpful:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/
odc_xlsmlinss.asp

Best Regards,

Mark Scott, Microsoft

Please do not send email directly to this alias. This is my online account
name for newsgroup participation only. This posting is provided "As is"
with no warranties, and confers no rights.

> Hi,
>
[quoted text clipped - 11 lines]
> Thank you,
> Dmitry

Reply to this Message

VB Forum / COM / October 2003

Excel Automation