Amerifax-Bob
Members-
Posts
16 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by Amerifax-Bob
-
Drop one line in Excel 2007
Amerifax-Bob replied to Amerifax-Bob's topic in Macro Express and Macro Express Pro
Thoraldus - Tried what you said, but that doesn't go to the last cell that was active, it goes to the very last cell in the spreadsheet. I want to return the the last cell I was working in and then go down 1 line. Steve - I will read what you posted a little more thoroughly and give it a try. Like I said above I want to, while working in Excel, return to the last cell I was working in and then drop down a line to the next row. Bob -
I need to drop down one line every time I go back into Excel. Here is the basic of what I'm trying to do. <WINDOW ACTIVATE Title="Microsoft Excel" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/> <MOUSE LEFT CLICK/> <GET MOUSE POSITION Option="\x01" X="%N[1]%" Y="%N[2]%"/> <DELAY Flags="\x01" Time="2"/> <MOUSE MOVE Option="\x01" X="300" Y="300" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="2"/> <GET MOUSE POSITION Option="\x01" X="%N[1]%" Y="%N[2]%"/> <DELAY Flags="\x01" Time="2"/> <TEXT TYPE Action="0" Text="<ARROW DOWN><ENTER>"/> It is not going down a line nor is it showing an active cell. Since I can not see an active cell, maybe it is going down a line. Bob
-
Copy range 315,158 to 770,325
Amerifax-Bob replied to Amerifax-Bob's topic in Macro Express and Macro Express Pro
>>Steve Casper - I still don't understand if you are trying to copy the text or paste it, though.<< Sorry I'm trying to append it to an open file call mba.txt-Notepad. Actually one line under the existing text that is in the file already. Bob -
Copy range 315,158 to 770,325
Amerifax-Bob replied to Amerifax-Bob's topic in Macro Express and Macro Express Pro
<WINDOW ACTIVATE Title="Copy range 315,158 to 770,325 - Macro Express Forums - Microsoft Internet Explorer" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/> <MOUSE MOVE Option="\x01" X="229" Y="429" _PROMPT="0x000A"/> <MOUSE LEFT BUTTON DOWN/> <MOUSE MOVE Option="\x01" X="480" Y="683" _PROMPT="0x000A"/> <MOUSE LEFT BUTTON UP/> <CLIPBOARD COPY/> I'm not sure what this means...Possibly it may be an editor that I am not familiar with. Could you maybe explain what the following lines are doing or what they mean? a.Macro Express Forums - Microsoft Internet Explorer" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/> b.Option="\x01" X="229" Y="429" _PROMPT="0x000A"/ Are these your own numbers to a location or are they some kind of a conversion of the numbers I provided in my macro? I am just trying to understand what the macro is doing. Bob -
Copy range 315,158 to 770,325
Amerifax-Bob replied to Amerifax-Bob's topic in Macro Express and Macro Express Pro
The URL is http://www.mbaonline.org/MBAGeoLocator/Con...ompanyID=194623 -
Copy range 315,158 to 770,325
Amerifax-Bob replied to Amerifax-Bob's topic in Macro Express and Macro Express Pro
Yes. I have been doing it manualy, all day long. Thats the point. For now I just want to get it to my buffer. After that I am going to want to append it to the bottom of an open document called "mba.txt - Notepad". When we append it, we are going to want to insert a space (or line) above it. Bob -
Not having much luck. I'm tring to copy a range with no luck. Activate Window: "Construction Services and Materials Report - Windows Internet Explorer" Mouse Move Window 315, 158 Mouse Left Button Down Mouse Move Window 770, 325 Mouse Left Button Up Clipboard Paste Bob I just switched to Pro and still no go.
-
In Excel I am doing a repetitive open and save operation. I have 3 different folder with about 100 files in each. I am opening each in Excel and then doing a save as. I am looking for a way to have the mouse return to the last position I was at and go down one. So that I can work through the directory. Thanks in advance for any help. Bob
-
Is there a more deliberate way to do a File - Open? I know you can do an Alt F then O. I was just looking for another way. Thanks, Bob
-
I am trying to write a Macro for logging into websites that I visit. I would like to write a general macro that will enter my username and password into the site so that I don't have to remember every username and password that I set up. I figure that if I set up one general macro I can work from there. I will set up an individual macro for each site that I want off of a template so to speak. I searched through all the commands to see if there was something to address the username or password end of it. Can anyone guide me in the right direction on this. Bob
-
Thanks for the help. Bob
-
MC Donald MIKE & MARY The "&" tells me a lot. The wife follows the &. Mike and Mary are easy to identifiy, most of the time. If the last name has a Mc Donald II Mike & Mary, thats not good either. The last name can be a problem. Has anyone worked with this problem. I need to end up with the following. Last Name = T1 First Name = T2 Secong Name = T3 Bob
-
This is the line of text I'm working with: County: LA CROSSE (55063) I have to high light "LA CROSSE". Which I will end up coping. Control rtarrow rtarrow will get me to the right of the "L" Using UltraEdit (Find) Text Type: <ALT>s Text Type: (<ENTER>c This will take me to the right of (55063) I need away to tell I have 9 charactors to copy, encluding the space. The text is from a database and the LA CROSSE could be and county name. Some are single as in "Milwaukee" and others are as "LA CROSSE". Bob
-
Someone had shown me a very simple way to dispay all the variables "t". it seems it was better than using the "Text Type". Any Help? Bob
-
This is how it works. Thanks for the help. I have accomplished four things here. I listed the items for people that might be doing a search. 1. Capture a value from the clipboard. Clipboard to variable. 2. Convert value to decimal. Text to decimal. 3. Do a bit of math, multiply. 4. Copy value back to the forum being used. Copy variable to forum. Activate Window: "Add Permits" Mouse Move Window 736, 420 Mouse Left Button Double Click Clipboard Copy Variable Set Decimal %D1% from Clipboard Variable Modify Decimal: %D2% = %D1% * 1000 Variable Modify Decimal: Convert %D2% to text string %T3% Mouse Move Window 736, 420 Mouse Left Button Double Click Text Type: %T3% Bob
-
>rberq<Thanks for the help. I got it to work but when I put in the value 4.75 the macro returned the value for "4". I have a feeling it's not seeing the decimal point properly. Could you help me with the adjustment I need to make so that the macro will process a number with a decimal point? Thanks a lot for your help. Activate Window: "Add Permits" Mouse Move Window 498, 302 Mouse Left Button Double Click Mouse Move Window 501, 303 Mouse Left Button Double Click Clipboard Copy Variable Set Integer %N1% from Clipboard Variable Modify Integer: %N2% = %N1% * 43560 Variable Modify Integer: Convert %N2% to text string %T3% Mouse Move Window 501, 303 Mouse Left Button Double Click Text Type: %T3% Bob
-
My message wasn't that clear at the time. I was trying to run two macros at once. I have since figured it out. Sorry for not replying sooner. Bob
-
I have been using Set Intereger and Modify Interger to do the following 1. Copy a number into a dbase forum. 2. Copy to Clipboard. ( Works fine) 3. Then save it to a "N1" -> Set Interger - Set Value from Clipboard Trying to put the value that's on clipboard into variable "N1" 4. Modity Interger-> Multiply - Variable to receive result "N2" - Variable "N1" x Value "43560 Trying to muliply "N1" x 43560 and put into "N2" 5. Put the result of step 3 into the original dbase forum location. Than somehow enter the "n2"value into forum. Activate Window: "Add Permits" Mouse Move Window 498, 302 Mouse Left Button Double Click Clipboard Copy Variable Set Integer %N1% from Clipboard Variable Modify Integer: %N2% = %N1% * 5 Mouse Move Window 622, 302 Mouse Left Button Double Click Clipboard Paste Hoping for help. Bob
-
I was abile to load the macro, "Load Netflix.mxe", from the command line. I still would like to be able to load "Macro Express" at the same time. Is that possabile. Bob
-
Thanks for the help with. It will come in handy in more ways the one. >>1. Auto execute Macro when "movie.mex" opens?<< 2. Position Internet Explorer on monitor screen, single monitor setup? 3. Position Internet Explorer on screen, on second monitor on a duel monitor setup? Bob
-
I’m in a different program and execute movie.mex from "Explore". When it opens Macro Express loads “Movie.mex” I want MP to automatically execute a macro, within “movie.mex”, called "netflix". The macro "netflix" should position Internet Explorer where I want on the screen. My main monitor would be fine. But can it be positioned on my second monitor? 1. Auto execute Macro when "movie.mex" opens? 2. Position Internet Explorer on monitor screen, single monitor setup? 3. Position Internet Explorer on screen, on second monitor on a duel monitor setup? Bob
-
I have two macros that I have to exacute. They work fine if I hold the keys for each one. F9 runs before I use F10. Is there a way to exacute the two macros with another Macro. I could use a different macro program to do this but I'm thinking Macro Express will do this. I tryied MacroRun with no luck. Bob
-
Close window command closes program instead.
Amerifax-Bob replied to Rustywinger's topic in Macro Express 3.x
Old messages never die. They just keep helping. Bob -
Run macros on program start and finish?
Amerifax-Bob replied to terrypin's topic in Macro Express 3.x
:rolleyes:I'm looking to do about the same. But I want to use a hot key to open a prorgam (If it's not already open). So it would be like a TOGGLE. IF IT'S OPEN IT WOULD THEN CLOSE. IF it's closed it would open. Very basic. I hope with both get some help. Bob -
set Ci to be the Error box string of text "Search string not found" Not sure what "Ci" is. Thanks again I'll try "In cases like this I do not actually open the file. What I do is to load the file into a text var and use Get Position to find the integer position of the search text" Bob