Bill Benson
vbacreations at gmail.com
Wed Jun 25 15:33:53 CDT 2014
I missed Stuart's astute observation as to why you were getting multiple instances of Excel. OTOH, I was reading it at 3AM after a long day/night and poor sleep. No excuse! No excuse! No excuse! No excuse! No excuse! No excuse! No excuse! No excuse! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Wednesday, June 25, 2014 4:22 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Automation Error 91 for Excel Checkbox Thank you Bill for your perseverance and Stuart for the reason I was having the problem. All solved. Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson Sent: Wednesday, 25 June 2014 7:18 p.m. To: Access Developers discussion and problem solving Subject: Re: [AccessD] Automation Error 91 for Excel Checkbox And stop using selection... ;) BB On Jun 25, 2014 3:13 AM, "Bill Benson" <bensonforums at gmail.com> wrote: > Yeah but I got rid of that. If I wanted to keep it I would have said > with xlobj.selection. > > Most self respecting excel programmers avoid selection. > On Jun 25, 2014 3:06 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> > wrote: > >> > With Selection >> > .Caption = "" >> >> Gee, it's over a year now since the last time this perennial query >> came up (April 2013 according to my records). :-) >> >> >> <standard quote> >> The old "unqualified reference" strikes again. >> >> See http://support.microsoft.com/kb/319832 >> >> When you write code to use an Excel object, method, or property, you >> should always precede the call with the appropriate object variable. >> If you do not, Visual Basic establishes its own reference to Excel... >> </standard quote> >> >> -- >> Stuart >> >> >> On 25 Jun 2014 at 18:50, David Emerson wrote: >> >> > Correction - closing the second spreadsheet doesn't close the >> > instance of Excel. Two instances now appear in Task manager. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com