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.