Amerifax-Bob

Can changing the resolution of a screen affect the exaction of a macro. I can see the possibility of a problem if the macro is using "Mouse Move". Are there other issues?

Did you every find a solution for your problem. You code sounds interesting.

I'll be waiting for that response also. I always red line the lines in the macro so they will not run. Pain.

I tried to fix my junk mail last week and did to good a job. I added you to the "Friend" list. Heather and I thought that it was strange we didn't hear from you. Your always good with email's. Bob

If I want to capture a Line I basically do the following: Variable Set to ASCII Char 13 to %CR% Variable Set to ASCII Char 10 to %LF% Variable Set String %Content% from the clipboard contents Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1 // Place values from SelectPhone into Excel Window Activate: Microsoft Excel Text Type (Simulate Keystrokes): %Line[1]% Text Type (Simulate Keystrokes): <TAB>%Line[2]% At times I only want to capture a part of a line as example: Phone: 262-353-3278 My Selection is made by: Ctrl+Shift(RightArrow), (RightArrow)(RightArrow), Shift (End) It seems to me I only need to change one line to do this: Text Type (Simulate Keystrokes): <TAB>%Line[2]% The following changes nothing. I still do get the entire Phone Line capture. I onlt want the number. Text Type (Simulate Keystrokes): <CTRLD><SHIFTD><ARROW RIGHT><CTRLU><SHIFTU><ARROW RIGHT><SHIFT><END><TAB>%Line[11]% Bob

Kevin - What you and others have helped me with over the last week or so has given my company a breath of fresh air. We are part of a dying industry "New Home Info". With this help we can now convert and check info against our master "Permit" data base. Before time would make it almost impossable to complete. Thanks again. Bob

Kevin, Wouldn't writing a file for every single record slow things down? If each record I copy gets written into a file I would think that would take a while. I could be completely wrong but... Learning is fun...but it's finally getting the result you've been working so hard at that makes it rewarding. I am going to play around with this a little bit with what you suggested and check it out. Thanks again! Bob

Well I don't know why, but for some reason I don't think the clipboard was liking the copy being done in the Phone directory program. So what I did was paste it into my text editor, re-copy it; then the macro ran through fine. I know it's an extra step but it seems to need it to recognize the data properly. I thought about what you said and tested it on some text that I typed in and it split the lines properly with that test, so it pointed to the phone program. Well now for the real test, 1000's of records...we'll see! Thank you again for your help and above all your patience with me. Bob

Kevin it seems your telling me it should be spliting the lines. Since it's not I must be missing something.

What exactly will a Hex Editor do for me and can you suggest one? I did try all the different combinations you suggested though. I tried, CR, LF and CRLF. Is there many more? Right now we use Ultra Edit which is a text editor and it shows a standard Paragraph mark at the end of each line. Does that count for anything? Actually I just found that UltraEdit has a HexEditor as part of the program. I looked at it but I have no idea what it means. At the end of every line I see an "OD OA" what does that mean? I attached an image file that I was hoping maybe you could look at and tell me what it is that I need from it. Actually I just found another part and it seems that it is using a CRLF. I have tried all these combinations...is there something I'm missing. Thanks again, Bob This is the furthest we have ever gotten with this. We usually end up getting frustrated and put the project on the shelf again. With the new update of Macro Express we thought we would give it another shot but...

I did notice that I am not getting my blank lines...do they get their own variable or are they skipped within the code?

Thanks for the explanation. I understand now what they are and what they do and why both really are necessary. But...in my macro this is what I ended up doing: Variable Set to ASCII Char 13 to %CR% Variable Set to ASCII Char 10 to %LF% // Place Clipboard into Variable Variable Set String %Content% from the clipboard contents Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1 I am using both but I am still getting the full results in the %Line[1]% Variable. Is there something else or another character I can try? Bob

I figured out that I was missing this: Variable Set to ASCII Char 13 to %CR% Variable Set to ASCII Char 10 to %LF% I placed this in my Macro right above the "Variable Set String from Clipboard" but I am still getting the same response. I am getting all the lines of text in %Line[1]%. Bob P.S. Where would I find those commands above "Char 13 and Char 10" it took me a minute to figure out and I remembered the same thing in one of Cory's messages and it finally hit me...

Cory, I am so sorry. I finally get it. Sometimes it takes a little while. Thank you for not giving up on me completely. Between this Topic and the other one, I think I have finally figured out what you have been trying to tell me for years about processing text.... Heather (and Bob)

OK I have been working with it and this is where I am now... Delay: 150 milliseconds Window Activate: ProCD PhoneBooks Wait for Window Title: ProCD PhoneBooks Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmo Text Type (Simulate Keystrokes): c Variable Set String %Content% from the clipboard contents Split String "%Content%" on "%CR%" into %Line%, starting at 1 Window Activate: UltraEdit Wait for Window Title: UltraEdit Text Type (Simulate Keystrokes): %Line[1]% Result: HESTAD JAMES 3905 LANCASTER LN N MINNEAPOLIS, MN 55441-1734 Phone: 763-546-8059 Listed Since: 04/2005 Residence County: HENNEPIN (27053) MSA: MINNEAPOLIS-ST PAUL, MN (5120) Latitude: 45.028860 Longitude: -93.402420 Precision: Geocoded to address precision I am not sure what I am doing wrong (and I'm thinking it's minor). I think I might have the wrong Character in my Split On. I've tried %CR% and %LF% and neither one works for me. I am getting all the lines in variable %Line[1]%. In my text editor, it shows a "paragraph" mark at the end of each line, which I thought was a standard return or enter. I am almost there. And it is so much faster. I can't thank you enough for sticking it out and pushing me to listen more! I have been searching the help and I just can't get over this last hump... Bob

First off...It seems Cory was trying to show us this procedure and we just weren't getting it (*sorry*). So I would like to thank Cory and Kevin for all their help with this matter! That said... I think I am finally starting to understand what you are trying to show here: Variable Set to ASCII Char 13 to %CR% Variable Set to ASCII Char 10 to %LF% 1st Line: Start with Character 13 and go to the "Return" and copy that into a Variable 2nd Line: Start with Character 10 and go to the "End of the Line" and copy that into a Variable So would I be correct in thinking that both lines are actually showing the same thing, just 2 different ways to do it? Variable Set String %Content% from the clipboard contents Split String "%Content%" on "%CR%%LF%" into %Lines%, starting at 1 // Here: %Lines[1]% contains line 1 %Lines[2]% contains line 2 Now this part is telling me... 1st line: Copy the contents of the clipboard to a Variable called "Content" 2nd line: Split the "Content" at the "Return" or "End of Line" into separate Variables called "Lines" starting with line 1. (Am I getting it???) Then to get my result into Excel or whatever I would text type "%Lines[1]%" etc. So even if I have a blank line that would still count as a Variable, in my case %Lines[5]%, and I just would not use or paste it. The second code you showed, I assumed that would process an entire file, if you had a long text file that you wanted to process? In my case my text will always be in the same format as below. After I copy it into variables and paste it, I copy the next record to the clipboard... So once I do my Capture (AltVMOC), I have this in the clipboard (and it usually always, if not always, follows this format): HAWKINSON Robert 5905 LANCASTER LN N MINNEAPOLIS, MN 55441-1734 Phone: 763-544-2029 Listed Since: 06/2007 Residence County: HENNEPIN (27053) MSA: MINNEAPOLIS-ST PAUL, MN (5120) Latitude: 45.088860 Longitude: -93.102420 Precision: Geocoded to address precision I am going to give it a try. Thanks again for all your help and patience! Bob

I might have an idea but I need someone to tell me if I'm going in the right direction. Example: HAWKINSON Robert 5905 LANCASTER LN N MINNEAPOLIS, MN 55441-1734 Phone: 763-544-2029 Listed Since: 06/2007 Residence County: HENNEPIN (27053) MSA: MINNEAPOLIS-ST PAUL, MN (5120) Latitude: 45.088860 Longitude: -93.102420 Precision: Geocoded to address precision This how I was doing it to the second line of text. // Select: Address to Excel var2 Clipboard Empty Text Type (Simulate Keystrokes): <ARROW DOWN><HOME><SHIFT><END> Clipboard Copy Text Type (Simulate Keystrokes): <ARROW DOWN><HOME><SHIFT><END> Variable Set String %T[2]% from the clipboard contents This is what I'm thinking. "Shift End" "Delete" each line. Than repeat each line. My problem is how to create variable. The "Text Type" box gives me the "Shift End" "Delete" and also the mention of variable. I don't have a clue on if I can even capture at this point and get the variable i need. I was thinking if I created a globe variable for capture so I could use it in the "Text Type". I'm a summing all this since I saw variable listed in the "Text Type" box. Bob

Kevin - It just dawned on me that you must have been thinking I had only one line of text. I see that would be easy. It would be nice if we had a feature that would allow us to get items from clipboard by "Line Number". Here's hoping. Bob >> HIRT PETER W299N7320 BREEZY CIR HARTLAND, WI 53029-8478 Phone: 262-538-1186 Listed Since: 10/2003 Residence County: WAUKESHA (55133) MSA: MILWAUKEE-WAUKESHA, WI (5080) Latitude: 43.150620 Longitude: -88.339320 Precision: Geocoded to address precision<<

I only place it in UltraEdit to create the variables. Since my clipboard has the text as Example: I don't know how to create the variable, in the clouds, with out seeing it. I do know the line numbers without having to see it. Bob HIRT PETER W299N7320 BREEZY CIR HARTLAND, WI 53029-8478 Phone: 262-538-1186 Listed Since: 10/2003 Residence County: WAUKESHA (55133) MSA: MILWAUKEE-WAUKESHA, WI (5080) Latitude: 43.150620 Longitude: -88.339320 Precision: Geocoded to address precision

It a Phone Directory. Using "Alt vmo" ids the only way to capture the date. Some of the data only exist on other windows within Directory Program. From here I past "Ctr V" into any text program. I use MultiEdit. The format is almost always on the money. Some times the "Phone" is missing. I only use Name - Address - City ST Zip - Listed Since - Latitude - Longitude, which I past into Excel-2007. This evening my biggest problem is closing the Vmo window so I can continue macro. "C closes the window. So I do alt vmoc. I even tryied the "C" in the next line as TYPE TEXT. // SelectPro - to Excel\T\File\Excel\SelectPro - to Excel (Waukesha Resident).xlsx Repeat Start (Repeat 1 times) Window Activate: ProCD PhoneBooks Wait for Window Title: ProCD PhoneBooks Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmo Also tried Text Type (Simulate Keystrokes): <ARROW DOWN><ALT>vmoc Text Type (Simulate Keystrokes): c Window Activate: UltraEdit Wait for Window Title: UltraEdit Text Type (Simulate Keystrokes): <CONTROL>a<DELETE> Sample of Text: HIRT KARI W24081 CLOVER DR SUSSEX, WI 53089 Phone: 262-372-4302 Listed Since: 01/2009 Residence County: WAUKESHA (55133) MSA: MILWAUKEE-WAUKESHA, WI (5080) Latitude: 43.124640 Longitude: -88.226040 Precision: Geocoded to address precision

Sorry somehow posted my message a few times. Just doing this to take out the extra space...sorry!

Sorry somehow posted my message a few times. Just doing this to take out the extra space...sorry!

Sorry somehow posted my message a few times. Just doing this to take out the extra space...sorry!

Cory it might seem like i'm not lisening but... There are days when we need to put "Cory" on the front door. We do thamk you for your great help but some times it is a bit over our heads. Example: variable manipulation commands visibleway I guess this was in the back of my mind when I said process on clipboard - Out ragious statement but only tring to make my point. I agree visual is killing the time when sharing only a couple of seconds amounts to hours each days. Right know I'm running 7 computers to process the date. But you have a skill, knowlege, that slips by me. I'm not using "variable manipulation commands" becouse I have a better way. I know this is what I need to learn. Again don't think for a second that you have not infuenced our operations. Bob

Cory >>But you can only lead a horse to water.<< Cory sorry to say I'm still looking for the horse. Bob PS I'l have Heather find that message from a month a go.