[AccessD] Automation Error 91 for Excel Checkbox

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jun 25 02:04:43 CDT 2014


>       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