[AccessD] Excel zombie won't die

Bryan Carbonnell carbonnb at sympatico.ca
Sat Aug 30 14:43:49 CDT 2003


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.




More information about the AccessD mailing list