Lonnie Johnson
prodevmg at yahoo.com
Wed Nov 9 06:43:00 CST 2005
Ok. I clean it up and send it. "Paul Hartland (ISHARP)" <paul.hartland at isharp.co.uk> wrote:In that case unfortunately I am stuck for another idea, I have never had a problem with Excel being open in the background after using Close, Quit, and setting both the workbook object and excel object to nothing.....Only other thing is to have a look at your code if you didn't mind....can send it to paul.hartland at orridge.co.uk if you want, I can have a quick look at it, but quite busy today. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson Sent: 09 November 2005 11:32 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access data to Excel Chart I tried that but then it tells me that I do not have permission to delete it. I think it is because Excel is still open in the background. I use the Close, Quit and set the Object to Nothing and still it is open more than once when I go to task manager after a few runs. "Paul Hartland (ISHARP)" wrote:The easiest thing I can think of is to check for the name your exporting to, if it exists either rename or kill it, then carry on with the export. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson Sent: 09 November 2005 02:34 To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; ms_access; Access Professionals; AccessD solving' Subject: [AccessD] Access data to Excel Chart I have been banging my head on this one. I have a query that I need to get the results into Excel, then create a pivot table, then create a three line chart from the pivot table. One successful attempt was to export the data into Excel, but then I get the message saying that "TableName" already exist after my first attempt. This will have to be done with automation over and over depending upon the user selections. Has anyone done this before and already has a device in place? I am running out of time and have been trying different options for over a week. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. -- 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 May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. -- 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 May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.