Check an object reference

's Computer Specifications

Using Office 2003 and Windows XP;

I have an object reference to a file, call it "goFile".

I need to be able to do two things with this reference:

1. Determine if the file it is refering to is open.

2. Determine if the reference is set to anything.

Could someone please post example code that illustrates these two things?

Thanks much in advance.

's Computer Specifications

if gofile is not nothing then
For Each wbk In Workbooks
if wbk.name = gofile then
' Enter code here
end if
next wbk
end if

"XP" wrote:

> Using Office 2003 and Windows XP;
>
> I have an object reference to a file, call it "goFile".
>
> I need to be able to do two things with this reference:
>
> 1. Determine if the file it is refering to is open.
>
> 2. Determine if the reference is set to anything.
>
> Could someone please post example code that illustrates these two things?
>
> Thanks much in advance.

's Computer Specifications

Hello,

Sorry to butt in but I think the actual syntax should be:

If Not gofile Is Nothing

HTH,
JP

On Oct 19, 5:50 pm, Joel <J...@discussions.microsoft.com> wrote:
> if gofile is not nothing then
> For Each wbk In Workbooks
> if wbk.name = gofile then
> ' Enter code here
> end if
> next wbk
> end if
>
>
>
> "XP" wrote:
> > Using Office 2003 and Windows XP;
>
> > I have an object reference to a file, call it "goFile".
>
> > I need to be able to do two things with this reference:
>
> > 1. Determine if the file it is refering to is open.
>
> > 2. Determine if the reference is set to anything.
>
> > Could someone please post example code that illustrates these two things?
>
> > Thanks much in advance.- Hide quoted text -
>
> - Show quoted text -

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use a Variable to Reference a Check Box Object	Ken Hudson	Microsoft Excel Programming	7	8th May 2009 11:12 PM
when i reference a com object by regsvr32 it then find it in the COM tab, it works ok. but when i reference a com object by referencing the .dll file i get this error in my C# application:	DR	Microsoft Dot NET	1	19th Jan 2008 05:01 PM
when i reference a com object by regsvr32 it then find it in the COM tab, it works ok. but when i reference a com object by referencing the .dll file i get this error in my C# application:	DR	Microsoft C# .NET	1	18th Jan 2008 08:18 AM
when i reference a com object by regsvr32 it then find it in the COM tab, it works ok. but when i reference a com object by referencing the .dll file i get this error in my C# application:	DR	Microsoft Dot NET Framework	0	18th Jan 2008 03:22 AM
How does one check if an object's reference is NULL?	Karen Hill	Microsoft C# .NET	4	15th Sep 2006 08:04 PM