[AccessD] Automation Error 91 for Excel Checkbox

David Emerson newsgrps at dalyn.co.nz
Wed Jun 25 15:21:57 CDT 2014


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.



More information about the AccessD mailing list