Amerifax-Bob

Cory, This is an example of the text I am putting into Variables. America In-Home T[2] 3485 N. 124th Street T[3] Brookfield T[4] WI T[5] 53005 T[6] 262-790-4050 T[7] 262-781-2849 T[8] www.americainhome.com T[9] There is not always a website. So when it gets to the point that it is going to select and copy the website to a Variable, I would like it to check first if the text contains www. If it does then continue on and copy the website to T[9] and if not, just continue on with the Macro. Sorry I should have clarified that more. Is that possible to check with an IF statement since it is not yet in a Variable, or should I use 2 variables in this instance. One to copy the line to a variable for checking and another to hold the proper variable if the condition is met? I did figure out the IF Variable within my Macro for other instances but this one was a little different. Heather

I am not very good with the IF statements and was wondering if someone could help with a small one for me? // Website to T9 Text Type (Simulate Keystrokes): <ARROW DOWN> Text Type (Simulate Keystrokes): <SHIFT><END> Clipboard Copy Delay: 250 milliseconds Variable Set String %T[9]% from the clipboard contents I would like to do the above only if the text=www. The text is in a regular text editor (Ultra Edit). The data I am copying to Variables does not always have a website. So if the Macro finds www I want it to process the part of the Macro above, if not just continue on with the rest of the Macro. I did try searching around first, but did not have much luck. Thanks for any help, Heather

OK...I will try adding the beep. I will also upgrade as well, I am still on 4.1.0.1. Thanks for the suggestions and help. Heather

Cory, Bob and I discussed that very thing. Not only searching a little more through the forum, but actually searching through our own messages we have posted. When we get through a problem we usually archive the message in our own "Help System" so to speak. We will check out that post and like always, thank you so much for your help and patience! I do however, have one more question. In the code I did do, can you see why I am ending with the "little guy" in the taskbar still? When I put in the number of times I want to repeat, I would think it would end after that, but the little guy remains. Maybe I am still missing something or not ending the Macro the proper way. It seems that I am getting a time error on Line 2. It pops up well after I am done running the Macro. Thanks, Heather

Cory, To answer your first question, we can't use a CTRL+A because we only want the text that is within the box on the page. I also added the second manual copy command like you suggested as well as some delays in a few spots. The time delays never really seem to be consistent though. I went through and added them and then took each one down until I had problems running the macro through. But it still is not consistent. It might run through 3 times and then start missing one or two. I also added a Repeat Prompt because there are always a different number of contacts or companies. This is the new code: Repeat Prompt Start Window Activate: Metropolitan Builders Association Wait for Window Title: Metropolitan Builders Association Wait for Left Mouse Click Delay: 1.5 seconds Window Activate: Construction Services Wait for Window Title: Construction Services Mouse Left Click Mouse Left Click Mouse Move: 2272, 660 Relative to Screen Delay: 300 milliseconds Mouse Left Button Down Mouse Move: 2758, 830 Relative to Screen Delay: 300 milliseconds Mouse Left Button Up Clipboard Empty Clipboard Copy Delay: 200 milliseconds Text Type (Simulate Keystrokes): <CONTROL>C Delay: 1 seconds Window Activate: UltraEdit Wait for Window Title: UltraEdit Text Type (Simulate Keystrokes): <CONTROL><END> Text Type (Simulate Keystrokes): <ENTER> Clipboard Paste End Repeat One other thing I did notice is that after the Macro is done running the "little man" is still in the Taskbar...am I missing something in the code? I tried with and without the repeat and either way he is still there. Thanks once again for all your help Cory. Heather (for Bob) PS We would really be interested is learning about the VBScript. We have dabbled in it a very little bit through other programs. Let me know how you want to do it...

Please see If it was ease we would not need Macro Exoress I am using 2 Internet Explorer Windows within my Macro. The first one contains different headings (which I need to select the one I want), once I click on a heading it loads a 2nd Internet Explorer window which contains the data I need to copy. When I copy the data, I am pasting it into Ultra Edit. Below is the Macro I put together. Window Activate: Construction Services Wait for Window Title: Construction Services Mouse Left Click Mouse Left Click Mouse Move: 2257, 677 Relative to Screen Mouse Left Button Down Mouse Move: 2750, 850 Relative to Screen Mouse Left Button Up Clipboard Empty Clipboard Copy Window Activate: UltraEdit Wait for Window Title: UltraEdit Text Type (Simulate Keystrokes): <CONTROL><END> Text Type (Simulate Keystrokes): <ENTER> Clipboard Paste Nothing seems to work consistent. I have tried adding time delays. The macro will run through a few times with no problems, then it misses the copy command. Can anyone suggest a better way to do this. If you want to see for yourself what I am doing, the first IE window is at www.mbaonline.org, click "Find a Member" in the upper right corner, click on I accept. Then click the Construction Services Tab and select a heading. At the bottom, different companies appear. If you click on "More Detail," the 2nd IE Window will open with the Text we are trying to copy. Thanks for any help or suggestions. Bob

>>I keep saying this but I'll try again<< I thought I was doing what you suggested by copying the cells as Variables. Evidently I'm not. Are you suggesting that I copy a range in Excel to another program such as Ultra Edit? Bob

We are running the following Macro and getting various results. Sometimes the Macro misses variables, sometimes they are doubled up but the results are never the same. What is missed or double one time, is fine the next time. The results are so random. This is the code: Clipboard Empty Window Activate: Microsoft Excel - Get Mouse Position into (%N[1]%, %N[2]%) Relative to Current Window // Name T1 Text Type (Simulate Keystrokes): <TAB> Clipboard Copy Variable Set String %T[1]% from the clipboard contents // Company T2 Text Type (Simulate Keystrokes): <ESC><TAB><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[2]% from the clipboard contents // Address T3 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 400 milliseconds Clipboard Copy Variable Set String %T[3]% from the clipboard contents // City T4 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[4]% from the clipboard contents // State T5 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[5]% from the clipboard contents // ZIP T6 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[6]% from the clipboard contents // Phone T7 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[7]% from the clipboard contents // Toll Free T8 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 350 milliseconds Clipboard Copy Variable Set String %T[8]% from the clipboard contents // Cell T9 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 400 milliseconds Clipboard Copy Variable Set String %T[9]% from the clipboard contents // WebSite T10 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 400 milliseconds Clipboard Copy Variable Set String %T[10]% from the clipboard contents // E-Mail T11 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 400 milliseconds Clipboard Copy Variable Set String %T[11]% from the clipboard contents // ALT E-Mail T12 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 400 milliseconds Clipboard Copy Variable Set String %T[12]% from the clipboard contents // Hour T13 Text Type (Simulate Keystrokes): <ESC><TAB> Delay: 650 milliseconds Clipboard Copy Variable Set String %T[13]% from the clipboard contents Window Activate: WordPad Wait for Window Title: WordPad Text Type (Simulate Keystrokes): %T[1]% Text Type (Simulate Keystrokes): %T[2]% Text Type (Simulate Keystrokes): %T[3]% Text Type (Simulate Keystrokes): %T[4]% Text Type (Simulate Keystrokes): %T[5]% Text Type (Simulate Keystrokes): %T[6]% Text Type (Simulate Keystrokes): %T[7]% Text Type (Simulate Keystrokes): %T[8]% Text Type (Simulate Keystrokes): %T[9]% Text Type (Simulate Keystrokes): %T[10]% Text Type (Simulate Keystrokes): %T[11]% Text Type (Simulate Keystrokes): %T[12]% Text Type (Simulate Keystrokes): %T[13]% These are the results: Roger 1030B Orlando Dr De Pere Doubled De Pere WI 54115-9094 920-336-2603 920-336-7775 Cell Phone shannon.gretz@mascocs.com Like I said the results are so random it never has the same problem twice. Any help would be greatly appreciated. Bob

I thought the Goto would let me go to the location that I saved as a Variable. Bob

Once I create the following: Get Mouse Position into (%N[1]%, %N[2]%) Relative to Current Window How do I use the "Goto" to get to the location? Bob

In the Text Type Box there are 3 options for "Playback". The first two I understand, but the 3rd I was having a little trouble with. I was hoping someone could explain it to me a little better? The Help states: Send Text Directly to Control If a Control Variable is previously defined, the text entered in this command is typed into the selected Window Control. The control chosen must be able to accept text input. Otherwise this command will appear to do nothing. What exactly does this mean? Thanks, Bob

I am copy name, company, address, city, state, zip, phone, etc into Text variables 2-15. I then want to paste the information into ACT! We are using ACT! Premium 2010. When I am pasting the Variables into each field, it seems that the tabs between the fields are not consistent. When I do a Text Type to drop the Variable into the proper fields, it seems that the when I drop the variable it is also dropping an enter at the end of the data. But when I thought that I figured it out, it didn't seem to be the case every time. Sometimes there is one too many tabs and some times there is one two few tabs. Not sure if maybe there is a better way to do things. I also wanted to make sure how long those items stay in their respective variable. If I have one macro that copies everything into the variable can I use another Macro to paste the variables into ACT? Do the variables stay as is until I overwrite them? Bob

Thanks Cory. That is exactly what I was looking for (your write-up). Sometimes that makes it so much easier to understand. Bob

When you create variables in one Macro, can you call that Macro with another Macro and use the variables associated or created in the first? Please see If it was ease we would not need Macro Exoress Would this be making the variables Global? If they are Global are they always on? Thanks for any help. Bob

By using the Macro I posted in the message above I was able to load 3 websites into one Window, each on their own tab. I had also written the following Macro to Load the same 3 websites. The macro below checks to see if the Website is already open and if not loads it (in it's own window). Variable Set String %Web Title 1% to "Netflix - " If Not Window "%Web Title 1%" is running Web Site, "http://www.netflix.com", using Internet Explorer End If Variable Set String %Web Title 2% to "DVD Empire" If Not Window "%Web Title 2%" is running Web Site, "http://www.dvdempire.com/", using Internet Explorer End If Variable Set String %Web Title 3% to "IMDb Pro" If Not Window "%Web Title 3%" is running Web Site, "http://pro.imdb.com/", using Internet Explorer End If I tried to piece the two Macros together but it isn't working. I want to use the Macro from the Post above because it loads all 3 sites into one IE window on seperate tabs. But I want the functionality of the 2nd macro to check if the Website is already open and if not then continue on. This is the way I pieced them together: Mouse Move: 1644, 1189 Relative to Screen Delay: 3 seconds Get Mouse Position into (%N[1]%, %N[2]%) Relative to Screen Variable Set String %Web Title 1% to "Netflix - " If Not Window "%Web Title 1%" is running Mouse Move: %N[1]%, %N[2]% Relative to Screen Mouse Left Click Text Type (Simulate Keystrokes): <DELETE> Delay: 1 seconds Text Type (Simulate Keystrokes): nf Delay: 1 seconds Text Type (Simulate Keystrokes): <ENTER> Delay: 3 seconds End If It seemed logical to me but I am getting a sytax error at line six. Sorry for such a long post but I was really hoping that someone could shed some light on this or guide me in the right direction. I basically want to use the Macro from the post above, but have the functionality of the Macro included with this message. Any help will be greatly appreciated! Bob

So far I have got to this point. Mouse Move: 1644, 1189 Relative to Screen Delay: 3 seconds Get Mouse Position into (%N[1]%, %N[2]%) Relative to Screen Mouse Left Click Text Type (Simulate Keystrokes): <DELETE> Delay: 1 seconds Text Type (Simulate Keystrokes): nf Delay: 1 seconds Text Type (Simulate Keystrokes): <ENTER> Delay: 3 seconds Mouse Move: %N[1]%, %N[2]% Relative to Screen Mouse Left Click Text Type (Simulate Keystrokes): <DELETE> Delay: 1 seconds Text Type (Simulate Keystrokes): de Delay: 1 seconds Text Type (Simulate Keystrokes): <ENTER> Delay: 3 seconds Mouse Move: %N[1]%, %N[2]% Relative to Screen Mouse Left Click Text Type (Simulate Keystrokes): <DELETE> Delay: 1 seconds Text Type (Simulate Keystrokes): im Delay: 1 seconds Text Type (Simulate Keystrokes): <ENTER> Delay: 3 seconds Note: Next 4 lines are unrelated to the macro. It's just the way I create shortcuts. The use of nf - de - im is a short cut I create in Reg HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\nf.exe nf.exe is http://dvdempire.com I use many short cuts this way. The only thing I have left to do is do some knid of check to make sure the sites are not already in Internet Explore. Some kind of an "IF" statement. I could use help on the "IF" Bob

I'm hoping to have three sites open on the same Window. I'm using XP Pro and Int Exp 7. I'm also using MacroExpress Pro 4.1.0.1 BOb

Is there a way to have a macro load an address. Than the next time if it is still loaded in Internet Exp, not load it again? Bob

I have noticed that if i open TreePad manualy, no macro the following takes place. Tree pad, after it opens, wants to place it's self it the closing position and it the size it was when last closed. I shorted it down to: Launch Program and Activate Window: Program "treepadxenterprise.exe", Parameters "", Window "TreePad X Enterprise" Delay: 4 seconds Window Reposition: TreePad X Enterprise Move to the bottom-left corner Here is what I get: TreePad open's it's self basted on the above condition but does not place it's self on the right monitor,"1". Fact: when opened manualy TreePad opens. Than it changes to another window to last open position and size than closes the original window. A 8 second delay don't even have an effect. Bob

I made a change: Launch Program and Activate Window: Program "treepadxenterprise.exe", Parameters "", Window "TreePad X Enterprise" Wait for Window Title: TreePad X Enterprise Window Resize: TreePad X Enterprise Size: 880, 600 Window Reposition: TreePad X Enterprise Move to the bottom-left corner a. The result was an open window of TreePad on the left monitor. b. A frome of the window, TreePad on the left monitor, where it should be. It is to the proper size and placement. But it's just a frame which has the TreePad name in upper left part of the frame as it should be. When I close the window of TreePad that's on the left monitor, original location, it also closes the replacement window on the right monitor. Remember the window of TreePad on the right monitor is noting more than a Frame, nothing in the middle except for the main window backgroung (Blue). Bob

I'm trying to change the size and location of a window. Note: No need to read the following three messages by amerifax, unless you want to tell be why (Current Window) is the fix for my problem. I sure would like to know. At least Current Window has me up and running. Launch Program and Activate Window: Program "treepadxenterprise.exe", Parameters "", Window "TreePad X Enterprise" Wait for Window Title: TreePad X Enterprise Window Resize: TreePad X Enterprise 384 Gb (single user) Size: 880, 600 Window Reposition: TreePad X Enterprise Position: 2716, 418 <LAUNCH PROGRAM AND ACTIVATE WINDOW Title="TreePad X Enterprise" Exact_Match="FALSE" Wildcards="FALSE" Path="C:\\PRG\\Office\\TreePadXSU\\treepadxenterprise.exe" Mode="\x00" Default_Path="TRUE" Wait="1" Wait_For_Program="7"/> <WAIT FOR WINDOW TITLE Title="TreePad X Enterprise" Partial="TRUE" Wildcards="FALSE" Indefinite="TRUE" Hours="0" Minutes="0" Seconds="0"/> <WINDOW RESIZE Option="\x01" Title="TreePad X Enterprise" Partial="TRUE" Wildcards="FALSE" Method="\x00" Width="880" Height="600" _IGNORE="0x0006"/> <WINDOW REPOSITION Option="\x01" Title="TreePad X Enterprise" Partial="TRUE" Wildcards="FALSE" Method="\x00" Left="2716" Top="418" Monitor="1" _IGNORE="0x0006"/> It loads the window but will not change size or location. No matter if I try to change location to monitor 1 or 2. I do want it on my right monitor #2. Bob

Copy the range is something I never thought of doing. So the general idea that we are talking about is removing the values from Excel as a range than do the manipulation. I would emagine removing the range would be the same as when I do a cell by puting the range into a variable. In the past going to a program and using the arrow key to go from cell to cell and doing a variable on each one seemed so easy. But things change. Bob

Why do I will I'm getting a slap on the wrist? This horse is still looking for the water. Yes I sure am open to a better way for the mouse trap. I keep on getting my finger cought in what used to work. Bob

I am trying to copy a few cells (A,B,C) from Excel. I am trying to copy them into Variables (one each). To test this out, I opened up Notepad and Pasted the Variables into there. Each time I run the Macro, It is only pasting the Value from Variable 1 (%T[1]%). Basically in A,B,C I have First Name, Middle Initial, Last Name; I go into A, copy, "Variable Set String T[1] from the clipboard, then I tab and do the same for B-T[2] and C-T[3]. When I try to paste I am only getting the value from T[1]: <TEXT TYPE Action="0" Text="%T[1]%<ARROW RIGHT>%T[2]%<ARROW RIGHT>%T[3]%"/> I have tried using only one Variable and pasting, but the only one that works (even alone) is T[1]. Do you know what I might be doing wrong? Heather (for Bob)

Steve, That did work. Thanks for the help. Bob