[AccessD] Export from Access to Excel

Air code for a workbook.  Don't know whether you can use a
template to add a sheet?

<snip>
    Workbooks.Add Template:= _
        "C:\Documents and
Settings\Stephen.BONDSOFTWARE\Application
Data\Microsoft\Templates\HWMorsinkProgressClaims.xlt"
</snip>

Stephen Bond 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Arthur Fuller
Sent: Thursday, 17 September 2009 4:31 a.m.
To: Stephen
Subject: [AccessD] Export from Access to Excel

Instead of the usual "blank sheet", I want to export to
Excel using a template (XLT) file. Can anyone tell me how to
modify the code so it uses the template instead?
TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com