J
jerem
Hi Graham,
I did not try your code since your original response (way back when)
mentioned replacing entries [A], with Include Text Fields using a
document to hold variable info with bookmarked items then an alternate method
was to put the variable info in individual documents, etc. It was getting a
little bit hairy and out of control with bookmarks, documents, etc. Then
Greg came in with the Array Code and it was compact (in that I wasn't having
to bookmark items or flip through various docs) and then there was a slew of
dialog amongst yourselves (you, Greg, Ed, Russ) that I wasn't quite sure what
you guys were talking about "Option Explicit", etc. And then you made a
comment "but I wonder if this would confuse beginners even more" which hit
the nail on the head - you guys were assuming a level of knowledge that I did
not possess - and while the dialog was interesting, there was one statement
that Greg made in response to Ed (I tried Ed's solution but I'm sure that was
error on my part) that caught my attention and that I had a sense of being
right - he said, "I still think I would use the array though instead of
having all of the routines and passing variables†(it was similar to me not
wanting to do the bookmarking and various documents you suggested). It
seemed like too much "stuff" for a simple task. I knew there had to be
simpler way and it seemed that Greg was on the cusp with the solution for me.
I hadn't tried your method (vFindText = Array) because in our previous
communications between us it seemed that I couldn’t get past the Autotext
code/Autotext entry issue. So, since I was getting so many attempts from
various individuals, I stuck with Greg because it seemed right to me (despite
my limited knowledge).
And, by the way, the “tags†[A], , etc. that are being used in my
documents are [AB], [ABA], [OB], etc. I only used [A]’s ’s as examples
for simplicity. I did, indeed, replace the text I needed to find in Greg’s
my Array statement.
So, long story short – it’s a tremendous plus to know the skill level of
your audience. As I’ve mentioned in various other posts – I’ve taken
programming courses eons ago – Assembly, Cobol so I have knowledge of If’s,
Then’s, Else, Loops, etc., but I do not speak VBA – my VBA is like my
Spanish. I can conjugate some verbs and know a few sentences here and there,
but stick me in Spain for a couple of months and I’m going to have to resort
to speaking English and drawing pictures to express myself.
Oh, and pass onto Susan – my husband’s not the sharing type either – was
sort of a metaphorical way of expressing my delight. Thanks Graham and all
of you out there. You are appreciated. Sorry if I disappointed you Graham,
Ed and Russ.
I did not try your code since your original response (way back when)
mentioned replacing entries [A], with Include Text Fields using a
document to hold variable info with bookmarked items then an alternate method
was to put the variable info in individual documents, etc. It was getting a
little bit hairy and out of control with bookmarks, documents, etc. Then
Greg came in with the Array Code and it was compact (in that I wasn't having
to bookmark items or flip through various docs) and then there was a slew of
dialog amongst yourselves (you, Greg, Ed, Russ) that I wasn't quite sure what
you guys were talking about "Option Explicit", etc. And then you made a
comment "but I wonder if this would confuse beginners even more" which hit
the nail on the head - you guys were assuming a level of knowledge that I did
not possess - and while the dialog was interesting, there was one statement
that Greg made in response to Ed (I tried Ed's solution but I'm sure that was
error on my part) that caught my attention and that I had a sense of being
right - he said, "I still think I would use the array though instead of
having all of the routines and passing variables†(it was similar to me not
wanting to do the bookmarking and various documents you suggested). It
seemed like too much "stuff" for a simple task. I knew there had to be
simpler way and it seemed that Greg was on the cusp with the solution for me.
I hadn't tried your method (vFindText = Array) because in our previous
communications between us it seemed that I couldn’t get past the Autotext
code/Autotext entry issue. So, since I was getting so many attempts from
various individuals, I stuck with Greg because it seemed right to me (despite
my limited knowledge).
And, by the way, the “tags†[A], , etc. that are being used in my
documents are [AB], [ABA], [OB], etc. I only used [A]’s ’s as examples
for simplicity. I did, indeed, replace the text I needed to find in Greg’s
my Array statement.
So, long story short – it’s a tremendous plus to know the skill level of
your audience. As I’ve mentioned in various other posts – I’ve taken
programming courses eons ago – Assembly, Cobol so I have knowledge of If’s,
Then’s, Else, Loops, etc., but I do not speak VBA – my VBA is like my
Spanish. I can conjugate some verbs and know a few sentences here and there,
but stick me in Spain for a couple of months and I’m going to have to resort
to speaking English and drawing pictures to express myself.
Oh, and pass onto Susan – my husband’s not the sharing type either – was
sort of a metaphorical way of expressing my delight. Thanks Graham and all
of you out there. You are appreciated. Sorry if I disappointed you Graham,
Ed and Russ.