[AccessD] Excel zombie won't die

I changed .open to .add. Thanks! As long as I've stared at that code I've
missed it. Nothing like another pair of eyes helping out.
Regards,
Jim Hale

-----Original Message-----
From: Bryan Carbonnell [mailto:carbonnb at sympatico.ca]
Sent: Saturday, August 30, 2003 2:44 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Excel zombie won't die


On 30 Aug 2003 at 11:57, Hale, Jim wrote:

> appExcel.Workbooks.Open _
> "C:\Documents and Settings\jhale\Application
> Data\Microsoft\Templates\PlanTemplate.xlt"
>  appExcel.ActiveWorkbook.Close SaveChanges:=False

DOH!! One other point.

Why are you opening a template? 

If you are trying to create a new workbook based on the template you 
should use:

appExcel.Workbooks.Add "C:\full\path\to\template.xlt"

---
Bryan Carbonnell - carbonnb at sympatico.ca
Normal people worry me.


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030830/5c6411ae/attachment-0001.html>