Amerifax-Bob

Problem is speed. Each time the macro runs if I can save 2-3 seconds it could amount to hours in a 24 hour day. The macro has apx 80 total lines of which 40-50 are a problem and these are the lines that do the data capture. The total macro takes 11 seconds to run. To capture 7 lines and turn them into variables it takes aproximately 9 seconds. It is capturing these 7 lines that I am trying to change from, right now it takes 9 seconds and I'd like to shave a couple seconds off of that. Basically what we are doing is pasting into a program called Ultra Edit, doing a control home, shift end and turn the value into a variable. We arrow down to the next line do another shift end and create another variable. And we do this for the next 5 lines of text. We are trying to find out if there is a better way to do that. Ideally it'd be nice if I could do my copy of the block of text and have the program see all the lines while it's in the buffer and create all my variables. Of course that would be similar to trying to play an MP3 file on your computer before you turn it on but actually we are looking for something that might be in between, just something better than shift end, down arrow... Bob

Thanks Cory...just wanted to make sure!

I did figure out the Repeat Command. And it is working pretty well for us. I will definitely start reading about Arrays to start to have a better understanding of the different options I might have to run some of these things we are doing. Bob

Are there any known problems with Windows 7 or Windows 7 64-bit and Macro Express Pro? Bob

I have a Macro that I am going to need to run against 100's of 1000's of records. How do I insert the syntax to run a loop in the Macro so that after it finishes running in continues until: A. It is end of the file OR B. It has processed a specified amount of records. I would like to be able to do it both ways. Bob

No %T[6]% because of the blank line. It is the 6 line that contains text so we used 6. Heather

Hey Cory, I was hoping to find you. You have always been able to work out our weird situations or requests. This is what I am working with: 2ND WIND EXERCISE EQUIPMENT W229N1416 WESTWOOD DR WAUKESHA, WI 53186-1309 Phone: 262-524-1678 Listed Since: 2005 Business County: WAUKESHA (55133) Sorry it is 7th line or %T[6]%. Where this equals Residential I am going to continue in my original Macro. If this value equal Business I want to call and run a different Macro - "Select(Business)" So: If %T[6]% equals Business Somehow run Macro Select(Business) Else Rest of Macro End If It is probably staring me in the face but... Heather

I have what I think may be a fairly easy situation, but I am not sure how to do it... I have text that I am copying into variables. I have a situation that will always exist. On the 6th line down into the text file or %T[6]% there is a consistent value, either Business or Residential, either way I want to copy that value into a Variable. Then If the text or variable equals Residential I want to run Macro A. If the text or Variable equals Business, I want to run Macro B. I have the rest of the Macros built I just need to know how to do this part of it. Thanks for any help. Heather

Thanks so much for the quick response. I will give that a try. Bob

I need help doing the following. I know it will need an if statement, I'm just not sure how to do it exactly. When searching for a value, using the find command, 1 of 2 things can happen: 1. If value is not found program will open a window with the name UltraEdit. 2. If the value is found, I want to highlight the word(s) by doing a Shift End and copying it to a variable. When running the macro without stopping, how do we know which value has been found? Thanks for any help. Bob

Still working it. Also I'm using Chrome-current but can just as well use IE if have to. Bob

I am trying to capture data from a webpage. On the page there is a record counter that tells you record 1 of 251. After capturing a record I want to move on to the next record. I know I can emulate a click on the button for the next record but how will Macro Express know that the record has actually changed. The site we are getting the data from is very data heavy so the pages take a little while to load. I thought maybe if I could edit the text or manually enter the record number that would help but I do not have that option and I suppose that would produce the same result as far as knowing when the new record is being displayed. This is the website I am searching: https://propertyinfo.revenue.wi.gov/iasWorld/Search/AdvSearch.aspx?mode=Advanced 1. Under Critera Select County Name, type in Washington then click Add. 2. Under Critera Select Date Recorded in From enter 01/01/2011 and in To field enter 02/01/2011 and click Add. 3. Then click on Search. 4. You will see a list of records, click on the 1st one in the list. Now you should be view the record. At the top left of the record you will see a box that says Current record with arrows for navigating through the records. When you click on the arrow to change records, how can Macro Express know when the next record is being displayed? I hope I explained this well enough, thank you in advance for any help you can give. Bob

Is there a way to use a NUMBER IN STEAD OF <ARROW RIGHT><ARROW RIGHT><ARROW RIGHT><ARROW RIGHT>. Kind of like 4<ARROW RIGHT>. This would be in the "Text Type". Bob

What is the advantage of using <SHIFTU> or <CTRLD>. If I need to use <CONTROL><SHIFT><ARROW LEFT><CONTROL><ARROW LEFT> should I be able to use <CTRLD><SHIFT><ARROW RIGHT><ARROW RIGHT><CTRLU> Not needing a Control between the Arrowright's. I know it seems like a funky question. Bob

I'm doing a find in Ultra Edit using Macro Express Pro, the latest. When value is not found I get a Window that displays "Search String "&&" Not Found. I can click on the Ok Button to close. Problem: How can I get the macro to continue. I have two conditions here. 1. It will find and hilight the value and let me continue as I always do. 2. It will let be select the OK button to continue but I still have to close the window with the upper right "X" window close button. It's like Continue if Value is found or select "OK" and close if not found. Bob

Thanks for the help Bob

I have a command I'm using that says: Get Mouse Position into (%N[1]%, %N[2]%) Relative to Current Window It is my understanding that this command will take the location of the mouse and store the location into variables. My question is, how does the program know where the mouse is located? How does it determine it's position? Thanks, Bob

I think I found my problem in Post -Simulate Keystrokes "Whoops!!!"- By having "Simulate Keystrokes" I was wiping out the screen I wanted to activate. So what is the big difference between Simulate Keystrokes" & " Use ClipBoard and Past Text". As long as I'm hear also "Send Text Directly to Control". Bob

After changing around for the last 3 hours I decided to give the forum a try. All works OK except I can not Activate UltraEdit. Window Activate: ProCD PhoneBooks Text Type (Simulate Keystrokes): <ALT>vmoc Wait for Window Title: UltraEdit Delay: 5 seconds Window Activate: UltraEdit Bob

Are you by chance a Viking Fan, as in Farve? Bob

I see a lot of great help. I'm going to try to get a better handle on it next week. I have been busy installing Windows 7 on a few computers. By the way it is the best install I have done and I go back before 32 Bob

Thanks for taking the time to respond to my message. I am going to check over my message now for inappropiate english. I am really sorry, I copied my original message out to a text editor to check the spelling, but when I copied the good text back in, I didn't delete the original "bad" message. I apologize for the confusion! Bob

I have been out for two weeks and left Heather a job that I could not even do. I thought it would be best to try to summarize her efforts. The following are her messages she used for help. 1. Erratic Copy Command 2. Variables in Multiple Macros 3. Diff Macros Dependent on one location This is what I'm trying to do: 1. http://www.mbaonline.org/MBAGeoLocator/Disclaimer.aspx a. Click - I accept b. Use tab "Find a Lot" c. First box - Search All d. Click - Search This will open the Explore window that is always loaded and open when macro is run. 2. We have to click on the "More Details". Each time we run the macro we have to execute the next "More Details". 3. The "More Details" opens a window that we copy all the info into variables. 4. We then paste the data into Excel, which works good with the Act! program that will receive the data. The macro we are trying to develop does not have to be involved with getting the data to Act! Copying and pasting the info works OK but is painfully slow. We do have two issues with our macro besides being slow. The macro starts with the second window http://www.mbaonline.org/MBAGeoLocator/Lot....aspx?recID=500 being open. The reason is because we use several versions of the same macro. They are dependent on how many lines are used in the "Company" box. All the copy and paste are done and the macro returns to the first IE window http://www.mbaonline.org/MBAGeoLocator/Lots.aspx. It is here that we have to select the next "More Details" button. This is our major problem. We are not trying to go thru all the pages listed as 1.2.3.4.5.6.7.8.9.10 etc. We are only trying to do the 10 "More Details" that are on the page. We would be happy to get this far. You would think we would start the macro with the http://www.mbaonline.org/MBAGeoLocator/Lots.aspx but due to the "Company" box having different amount of lines we have to take a look first and than select the macro that works. They are all the same macro except for the copy we do in the "Company" box. The following is the macro we use if there are 10 lines in the box. // Resize 2nd Monitor to 1920 X 1200 before running macro Window Reposition: Lot Report - Windows Internet Explorer Position: 1922, 2 Window Resize: Lot Report - Windows Internet Explorer Size: 860, 1162 Window Reposition: Metropolitan Builders Association : Members - Windows Internet Explorer Position: 2892, 2 Window Resize: Metropolitan Builders Association : Members - Windows Internet Explorer Size: 933, 1162 Window Activate: Lot Report - Windows Internet Explorer Wait for Window Title: Lot Report - Windows Internet Explorer Delay: 250 milliseconds Mouse Move: 637, 283 Relative to Current Window Delay: 250 milliseconds Mouse Left Click Mouse Left Button Down Delay: 250 milliseconds Mouse Move: 784, 490 Relative to Current Window Delay: 250 milliseconds Mouse Left Button Up Clipboard Empty Clipboard Copy Delay: 250 milliseconds Window Activate: UltraEdit - Wait for Window Title: UltraEdit - Clipboard Paste Delay: 250 milliseconds Text Type (Simulate Keystrokes): <ENTER> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Wait for Window Title: Find Text Type (Simulate Keystrokes): Company: Text Type (Simulate Keystrokes): <ENTER> Text Type (Simulate Keystrokes): <DELETE> Text Type (Simulate Keystrokes): <DELETE> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Wait for Window Title: Find Text Type (Simulate Keystrokes): Contact Name: Text Type (Simulate Keystrokes): <ENTER> Text Type (Simulate Keystrokes): <DELETE> Text Type (Simulate Keystrokes): <DELETE> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Wait for Window Title: Find Text Type (Simulate Keystrokes): Contact Phone Number: Text Type (Simulate Keystrokes): <ENTER> Text Type (Simulate Keystrokes): <DELETE> Text Type (Simulate Keystrokes): <DELETE> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Delay: 250 milliseconds Text Type (Simulate Keystrokes): <CTRLD>f<CTRLU> Wait for Window Title: Find Text Type (Simulate Keystrokes): Website: Text Type (Simulate Keystrokes): <ENTER> Text Type (Simulate Keystrokes): <DELETE> Text Type (Simulate Keystrokes): <DELETE> Delay: 250 milliseconds // Company to T50 Text Type (Simulate Keystrokes): <CONTROL><HOME> Text Type (Simulate Keystrokes): <SHIFT><END> Clipboard Empty Clipboard Copy Delay: 150 milliseconds Variable Set String %T[50]% from the clipboard contents // Contact Name to T51 Text Type (Simulate Keystrokes): <ARROW DOWN> Text Type (Simulate Keystrokes): <HOME> Text Type (Simulate Keystrokes): <SHIFT><END> Clipboard Empty Clipboard Copy Delay: 150 milliseconds Variable Set String %T[51]% from the clipboard contents // Phone Number to T52 Text Type (Simulate Keystrokes): <ARROW DOWN> Text Type (Simulate Keystrokes): <HOME> Text Type (Simulate Keystrokes): <SHIFT><END> Clipboard Empty Clipboard Copy Delay: 150 milliseconds Variable Set String %T[52]% from the clipboard contents // Website to T53 Text Type (Simulate Keystrokes): <ARROW DOWN> Text Type (Simulate Keystrokes): <HOME> Text Type (Simulate Keystrokes): <SHIFT><END> Clipboard Empty Clipboard Copy Delay: 150 milliseconds Variable Set String %T[53]% from the clipboard contents Text Type (Simulate Keystrokes): <CONTROL>a Text Type (Simulate Keystrokes): <DELETE> // Paste into Excel Window Activate: MBA-Find a Lot.xlsx Wait for Window Title: MBA-Find a Lot.xlsx Wait for Left Mouse Click Delay: 250 milliseconds If Variable %T[50]% Exists "" Text Type (Simulate Keystrokes): %T[50]% Delay: 150 milliseconds Text Type (Simulate Keystrokes): <ENTER> Else Text Type (Simulate Keystrokes): <ENTER> End If If Variable %T[51]% Exists "" Text Type (Simulate Keystrokes): %T[51]% Delay: 150 milliseconds Text Type (Simulate Keystrokes): <ENTER> Else Text Type (Simulate Keystrokes): <ENTER> End If If Variable %T[52]% Exists "" Text Type (Simulate Keystrokes): %T[52]% Delay: 150 milliseconds Text Type (Simulate Keystrokes): <ENTER> Else Text Type (Simulate Keystrokes): <ENTER> End If If Variable %T[53]% Exists "" Text Type (Simulate Keystrokes): %T[53]% Delay: 150 milliseconds Text Type (Simulate Keystrokes): <ENTER> Else Text Type (Simulate Keystrokes): <ENTER> End If Macro Run: MBA-FindaLot PS Thanks Heather for getting us this far. And all that have helped her along the way. Bob

In a nut shell: I'm using 5 macros that are dependent on one master document. The doc has 5 buttons that I must use, depending on my last position on the doc. Please see If it was ease we would not need Macro Exoress Please bear with me...this has been a difficult for me to try and figure out so its kinda hard to explain too. I have 5 macros that I am running. At the end of each Macro it needs to know where the mouse last was on a specific Web Page. Each Macro I am running is based on the Text that it needs to capture. So as the macro runs through, at the end, I would like it to return to the Web Page, find the last position of the mouse when it was there last and move down 0,26 and click again and save that new location for the next Macro to find. Does this make sense? The Click loads the page that we want to capture. After the page is loaded, based on the text we need to capture we will run 1 of the 5 Macros. After that Macro is done, we want it to return to that original web page, go to the last location of the mouse, go down (0,26), left click to load the new page for capturing, and based on what is loaded we will then decide which of the 5 Macros we need to run. So all 5 Macros need to know which position to return to and move down (0,26). There are a total of 10 buttons for each page. We will manually switch the page and then we will set the position at the 1st button again. Hope this makes sense. Heather