Yes sir
That did it.
I decided to go ahead and just clear all variables that are writing and deleting paths
'Clear all Path Variables
CurrPaths = Null
DeletePath(0) = Null
NewPath(5) = Null
Allpaths = Null
It is a good programming habit to set your variables to nothing (for obj)
and Null (for String)
I usually don't but this was a prime example as to why it needs to be done "ESPECIALLY" if you are running the macro again and again without closing down the project. It must be that the variable is retaining the information (in memory) that was last written to it until you close the project or set it to null or nothing.
As far as the InStr Function, that is a good one, i will have to remember that and use it sometime
As far as arrays, i think they are very powerful and very efficient, I have never really had a problem with them except in one case where I was writing the paths directly to the registry.
In that VBScipt, I used 3 arrays and 2 out the 3 worked find.
For the 3rd one I just folded and ended up using
.regwrite
Path & ";" & Path & ";" Path & ";"
And it gets the job done.
Keith B. was explaining to me about splitting paths which was very interesting but I was not quite sure of the precise method of making that work, so I left good enough alone.
Have you heard of Split?
Thanks again,
Mark