Bill Benson
bensonforums at gmail.com
Wed Jun 25 02:13:29 CDT 2014
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 >