My friends, Greg, Graham, It looks like the last four lines of the document are only two lines in my original. Pasting it here seems to have changed it. I didn't notice it earlier.
Normally it would highlight and copied "Joe Jones" - four lines up from the bottom.
And yes, it is a Mash of text, isn't it? It kind of grew as I increased my Macros.
I know it is a monster. But it serves me well, because I know where everything is, more importantly, my Macros know where everything is.
Nevertheless, I know I should start over from scratch to organize it.
All this has been a learning experience.
I have been referring to my final document. Actually, the final document is Microsoft Active Directory. I am adding records, every day. I know I must see if Power Shell can help me with that. Then it will be an easy matter to assemble all the different items, (name, address, agency, etc.), - into something that PowerShell can understand.
Right now, I retrieve one piece of information at a time from the document, and paste it in Active Directory. About ten of us do it the same way, except I am the only one using Macros. We all type or paste all the information in different GUI screens in Active Directory.
I will study your code, thank you very much. You have been a big help. Now I need to go learn PowerShell too.
You know, I believe that VBA is more difficult than COBOL.
|