View Single Post
 
Old 07-18-2017, 07:05 AM
StephenRay StephenRay is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

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.
Reply With Quote