<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Excel zombie won't die</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Regards,</FONT>
<BR><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Bryan Carbonnell [<A HREF="mailto:carbonnb@sympatico.ca">mailto:carbonnb@sympatico.ca</A>]</FONT>
<BR><FONT SIZE=2>Sent: Saturday, August 30, 2003 2:44 PM</FONT>
<BR><FONT SIZE=2>To: Access Developers discussion and problem solving</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Excel zombie won't die</FONT>
</P>
<BR>
<P><FONT SIZE=2>On 30 Aug 2003 at 11:57, Hale, Jim wrote:</FONT>
</P>
<P><FONT SIZE=2>> appExcel.Workbooks.Open _</FONT>
<BR><FONT SIZE=2>> "C:\Documents and Settings\jhale\Application</FONT>
<BR><FONT SIZE=2>> Data\Microsoft\Templates\PlanTemplate.xlt"</FONT>
<BR><FONT SIZE=2>> appExcel.ActiveWorkbook.Close SaveChanges:=False</FONT>
</P>
<P><FONT SIZE=2>DOH!! One other point.</FONT>
</P>
<P><FONT SIZE=2>Why are you opening a template? </FONT>
</P>
<P><FONT SIZE=2>If you are trying to create a new workbook based on the template you </FONT>
<BR><FONT SIZE=2>should use:</FONT>
</P>
<P><FONT SIZE=2>appExcel.Workbooks.Add "C:\full\path\to\template.xlt"</FONT>
</P>
<P><FONT SIZE=2>---</FONT>
<BR><FONT SIZE=2>Bryan Carbonnell - carbonnb@sympatico.ca</FONT>
<BR><FONT SIZE=2>Normal people worry me.</FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>