[AccessD] Start Excel Automation

You probably don't set your object(s) to Nothing after executing your
code.

Like 
set objExcel = Nothing



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carlo van der
Zon (Access IT Training)
Sent: Wednesday, March 08, 2006 8:21 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Start Excel Automation

Hi 

I start Excel from code, fill a list, and Works fine. 
I recorded a macro to create a pivottable, paste it in the Access code
and it Works fine.

But just only the first time!! Is there any way to make sure just only 1
Excel instance is running??

Thanks
Carlo



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com