<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] Excel zombie won't die</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Courier New" size=2>I would like to thank Jim for asking this
question,</FONT></DIV>
<DIV><FONT face="Courier New" size=2>and all of those of You that
responded.</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>I've been watching the thread closely as
I've run </FONT></DIV>
<DIV><FONT face="Courier New" size=2>into this </FONT><FONT face="Courier New"
size=2>in the past, and never thought to ask</FONT></DIV>
<DIV><FONT face="Courier New" size=2>the group. </FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>I'll be keeping the answer handy for the
future.</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Dave</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jim.hale@fleetpride.com href="mailto:jim.hale@fleetpride.com">Hale,
Jim</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">'Access Developers discussion and
problem solving'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, August 30, 2003 4:42
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Excel zombie won't
die</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>