Lonnie Johnson
prodevmg at yahoo.com
Wed Nov 9 05:32:29 CST 2005
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)" <paul.hartland at isharp.co.uk> 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.