[dba-VB] CreateObject, GetObject Functions

Adam Borrie AdamB at peabody.org.uk
Thu May 13 08:36:59 CDT 2004


Yes indeed it does.  I have tried error trapping for the run-time error that
a failed GetObject function produces so that when it happens I perform the
CreateObject function.  But there must be another way of doing it surely?
Adam Borrie
Systems Manager
Peabody Trust
*  0207 021 4439
* adamb at peabody.org.uk

> ----------
> From: 	Seth Galitzer[SMTP:sgsax at ksu.edu]
> Reply To: 	dba-vb at databaseadvisors.com
> Sent: 	13 May 2004 14:19
> To: 	dba-vb at databaseadvisors.com
> Subject: 	Re: [dba-VB] CreateObject, GetObject Functions
> 
> Adam,
> 
> If you try to run a GetObject and the object doesn't exist, does it
> return an error value?  If so, you can simply always run GetObject
> first, and if it returns an error then run CreateObject.
> 
> Just a thought.
> 
> Seth
> 
> On Thu, 2004-05-13 at 08:10, Adam Borrie wrote:
> > Question:
> > 
> > I am trying to set the value of a Boolean variable on the basis of
> whether
> > an instance of Excel is running.  In doing this I can then determine
> whether
> > to perform a CreateObject or GetObject function.
> > 
> > Do any of you have any suggestions.
> > 
> > Cheers
> > 
> > Adam Borrie
> > Systems Manager
> > Peabody Trust
> > *  0207 021 4439
> > * adamb at peabody.org.uk
> > 
> > 
> >
> ##########################################################################
> ###########
> > This e-mail message has been scanned for Viruses and Content and cleared
> 
> > by MailMarshal
> > For more information please visit www.marshalsoftware.com
> >
> ##########################################################################
> ###########
> > 
> > This email and any files transmitted with it are confidential and
> intended
> > solely for the use of the individual to whom it is addressed. Any views
> or 
> > opinions presented are solely those of the author and do not necessarily
> 
> > represent those of the Peabody Trust.
> > 
> > If you are not the intended recipient, be advised that you have received
> this 
> > email in error and that any use, dissemination, forwarding, printing, or
> 
> > copying of this email is strictly prohibited. If you have received this
> email 
> > in error please notify the Peabody Trust IT Help Desk either by;
> > 
> > Emailing helpdesk at peabody.org.uk 
> > 
> > Or by telephone on 020 79287811
> > 
> > Peabody Trust - http://www.peabody.org.uk
> > 
> > Please note that Peabody Trust encorporates  Waltham Forest Community
> Based Housing Association and Safe in the City.
> > 
> > This footnote also confirms that MailMarshal and Network Associates
> Total 
> > Virus Defense software's have swept this email message for the presence
> of 
> > computer viruses http://www.marshalsoftware.com and http://www.nai.com
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> -- 
> Seth Galitzer			sgsax at ksu.edu
> Computing Specialist		http://puma.agron.ksu.edu/~sgsax
> Dept. of Plant Pathology
> Kansas State University
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 

#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
For more information please visit www.marshalsoftware.com
#####################################################################################

This email and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. Any views or 
opinions presented are solely those of the author and do not necessarily 
represent those of the Peabody Trust.

If you are not the intended recipient, be advised that you have received this 
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited. If you have received this email 
in error please notify the Peabody Trust IT Help Desk either by;

Emailing helpdesk at peabody.org.uk 

Or by telephone on 020 79287811

Peabody Trust - http://www.peabody.org.uk

Please note that Peabody Trust encorporates  Waltham Forest Community Based Housing Association and Safe in the City.

This footnote also confirms that MailMarshal and Network Associates Total 
Virus Defense software's have swept this email message for the presence of 
computer viruses http://www.marshalsoftware.com and http://www.nai.com



More information about the dba-VB mailing list