dave sharpe
davesharpe2 at cox.net
Sat Aug 30 15:51:29 CDT 2003
RE: [AccessD] Excel zombie won't dieI would like to thank Jim for asking this question, and all of those of You that responded. I've been watching the thread closely as I've run into this in the past, and never thought to ask the group. I'll be keeping the answer handy for the future. Dave ----- Original Message ----- From: Hale, Jim To: 'Access Developers discussion and problem solving' Sent: Saturday, August 30, 2003 4:42 PM Subject: RE: [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 ------------------------------------------------------------------------------ _______________________________________________ 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/6240f88d/attachment-0001.html>