Newbie General Programming ??
 

Hi; Just Wondering;

Does it really make a difference if you don't test for a previous condition
before making a change to a format etc. in VBA? For example, will I hurt
anything or endager anything if I just do:

'Make condition = True' no matter if the existing condition has already been
met, rather than:

'If condition = False Then make condition = True'

It seems sometimes I spend a lot of coding time look for the state of
conditions when I really don't care. I just want everything to be the same.

Regards Bill

Newbie General Programming ??
 

specifics would be better, but in general, if you don't care what the current
condition is and you want the situation to be a specific condition
regardless, there is no reason to check.

Range("a1:B6").name = "MyName"

will create MyName if it didn't exist and redefine it if it did as an
example.

Another example. If I want to put a file in a subdirectory, if I know the
the higher level directory is there (C:\Data in the example), I can do

' ignore the error if it already exists
On error resume next
mkdir "C:\Data\Subdir"
On error goto 0
Activeworkbook.SaveAs "C:\Data\Subdir\MyFile.xls"

You then don't have to check if SubDir exists before doing this.

--
Regards,
Tom Ogilvy




"Bill Case" wrote:

Hi; Just Wondering;

Does it really make a difference if you don't test for a previous condition
before making a change to a format etc. in VBA? For example, will I hurt
anything or endager anything if I just do:

'Make condition = True' no matter if the existing condition has already been
met, rather than:

'If condition = False Then make condition = True'

It seems sometimes I spend a lot of coding time look for the state of
conditions when I really don't care. I just want everything to be the same.

Regards Bill

Newbie General Programming ??
 

Thanks Tom;

Yes , that was the kind of gerneral answer I was looking for. You may
rember in one of my previous posts that I had some beginners general
programming questions. You suggested I could ask on this list. So I just
did. That question was one of them.

Regards Bill

"Tom Ogilvy" wrote:

specifics would be better, but in general, if you don't care what the current
condition is and you want the situation to be a specific condition
regardless, there is no reason to check.

Range("a1:B6").name = "MyName"

will create MyName if it didn't exist and redefine it if it did as an
example.

Another example. If I want to put a file in a subdirectory, if I know the
the higher level directory is there (C:\Data in the example), I can do

' ignore the error if it already exists
On error resume next
mkdir "C:\Data\Subdir"
On error goto 0
Activeworkbook.SaveAs "C:\Data\Subdir\MyFile.xls"

You then don't have to check if SubDir exists before doing this.

--
Regards,
Tom Ogilvy




"Bill Case" wrote:

Hi; Just Wondering;

Does it really make a difference if you don't test for a previous condition
before making a change to a format etc. in VBA? For example, will I hurt
anything or endager anything if I just do:

'Make condition = True' no matter if the existing condition has already been
met, rather than:

'If condition = False Then make condition = True'

It seems sometimes I spend a lot of coding time look for the state of
conditions when I really don't care. I just want everything to be the same.

Regards Bill

Newbie General Programming ??
 

No problem.
It wasn't a criticism - just a caution that a general answer might not be
true in a specific situation - so if you had a specific situation in mind,
blah blah :-)

--
Regards,
Tom Ogilvy

"Bill Case" wrote in message
...
Thanks Tom;

Yes , that was the kind of gerneral answer I was looking for. You may
rember in one of my previous posts that I had some beginners general
programming questions. You suggested I could ask on this list. So I just
did. That question was one of them.

Regards Bill

"Tom Ogilvy" wrote:

specifics would be better, but in general, if you don't care what the
current
condition is and you want the situation to be a specific condition
regardless, there is no reason to check.

Range("a1:B6").name = "MyName"

will create MyName if it didn't exist and redefine it if it did as an
example.

Another example. If I want to put a file in a subdirectory, if I know
the
the higher level directory is there (C:\Data in the example), I can do

' ignore the error if it already exists
On error resume next
mkdir "C:\Data\Subdir"
On error goto 0
Activeworkbook.SaveAs "C:\Data\Subdir\MyFile.xls"

You then don't have to check if SubDir exists before doing this.

--
Regards,
Tom Ogilvy




"Bill Case" wrote:

Hi; Just Wondering;

Does it really make a difference if you don't test for a previous
condition
before making a change to a format etc. in VBA? For example, will I
hurt
anything or endager anything if I just do:

'Make condition = True' no matter if the existing condition has already
been
met, rather than:

'If condition = False Then make condition = True'

It seems sometimes I spend a lot of coding time look for the state of
conditions when I really don't care. I just want everything to be the
same.

Regards Bill