Tom and Aaron,
thanks. Works like a dream. We all still are learning. Smile.
----- Original Message -----
From: "Tom Kingston" <[email protected]>
To: <[email protected]>
Sent: Saturday, November 26, 2011 11:02 PM
Subject: Re: Checking if an object is available
Initialize the MyFile variable as Nothing and reset it to Nothing after
every close. You're getting the error that it's not defined because it
isn't.
Hth,
Tom
On 11/26/2011 4:44 PM, David wrote:
In one of my apps, I am trying to figure a way to perform the following;
if such is possible, that is.
I have a FileSystemObject defined as FS. Then somewhere in the code, I
have a line like:
Set MyFile = FS.OpenTextFile( "test.txt", 1, False)
This to open a textfile object, in the Object MyFile.
A third place in the code, I want to check if the MyFile object is
active. If it is, I want to have it closed.
I tried this:
If Not MyFile Is Nothing Then MyFile.Close
This works in some cases, but other times I am getting an error message,
saying the object is undefined. Seems to me, if the object has been in
use once, it works, but not if there has been no call for the object
through the process.
OK, so my Question:
Is there any way for me, to check to see if an object has been defined,
and is active? Some way, that will not leave me with an error message?
Thanks for any idea.
