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