Jump to content
Macro Express Forums

monpasdg

Members
  • Posts

    30
  • Joined

  • Last visited

Posts posted by monpasdg

  1. I get a lot of pdf documents from my bank - all of them protected with a password.

    I've created a very simple macro which types the password + ENTER.

    When I try to open the pdf I'm of course asked to type the password. I run the macro but nothing happens.

    If I open notepad and run this macro it works flawlessly.

    Why doesn't the macro work with the protected pdf document?

    Thanks for any help.

     

    Oded.

     

    Two suggestions:

    Make sure the typing code is typing and isn't doing "paste". Should be a radio button option on the typing code.

     

    Second would be to make sure the password screen has focus before typing. This can be done by putting a delay before the typing code or a "activate window"

     

    Regards,

     

    Don

  2. Hi,

     

    I'm a newbie, but all I want to do is to be able to take the active window and move it to the next monitor. So if the window is on monitor 1, and I have 3 monitors, move it to monitor 2, and then with another press of the hotkey, to monitor 3. After it gets to monitor 3, then it would move it back to monitor 1. I can't seem to fiture it out with just the window reposition commands. Can someone help?

     

    If you are using windows 7, you can hold down the win key and use arrows to move the active window around.

     

    e.g. Win + right arrow move screen one monitor to the right

  3. I suggest staying away from any mouse related activities on a web page.

     

    I use the tab technique suggested above but I also use a "home" key that puts the cursor in the same spot every time.

     

    Depending on what browser you use, I have ME press 'F4' which puts the focus in the address bar ("home"). Then do repeat x times <tab> to get to the desired field.

     

    Hope it helps

  4. Hello,

     

    I tried incorporating the following keystroke combination (Shift + Control) into a macro and the macro is halted and doesn't seem to recognize that keystroke combination. Should this be happening?

     

    Brian.

     

    The application you're running it in might have something to do with it.

     

    Does this control + shift work else where? If so, you might be forced to use a different combination due to the application blocking it

  5. Hello,

     

    This could get quite complicated using email :).

     

    Since your sending emails from youre phone I'm guessing you have a smart phone. If you have a smartphone (Android and Iphone for sure) you could get logmein ignition. I use this from my iphone and its quite nice for remote desktoping to my PCs. The interface takes a bit to get used to but I think it was very well done.

     

    Iphone: https://secure.logmein.com/products/ignition/iphone/

    Android: https://secure.logmein.com/welcome/android/

     

     

    Cheers,

     

    Don

  6. Hello!

     

    Looks like you're repeating just the text typing and not delaying of the macro.

     

    Try something like this:

     

     

    Repeat start

    text type- 2

    delay- 5 seconds

    repeat end

     

    Cheers,

     

    Don

     

     

    I've tried different variations with no luck. Any ideas?

  7. Recording on a game doesn't work very well. Macro express works well if you script it specifically to move the mouse.

    IE dragging something using mouse commands

    "move mouse to x,y" coordinates

    Left mouse click down

    "move mouse to x,y" coordinates

    Left mouse click up

     

    I don't play starwars galaxy but this works in other games I play. Note window mode works best just remember to keep the window in the same spot or your mouse moves won't match up when you try to run the macro.

     

    I can't post code examples due to being on my iPhone. Good luck!

  8. Hey NeVer,

     

    I think i had to do something like this a few years back.

     

    If i can remember correctly, what i did was use the search function in the Internet Exploer (Ctrl + F). I would have that find the phrase i was looking for and it would be highlighted.

     

    The macro then closed the search box (Alt + F4 is what i did) and just hit Tab since the text box i was trying to get to was the next to 'tab' to.

     

     

    Cheers,

     

    Don

  9. What about using the Find And Replace inside excel?

     

    You could make the macro type in the fields what you are looking for what to replace it with then press <Alt> + A and it will replace all of the cells that match that criteria.

     

    All the fields that you need to use can be activated using short cut keys.

     

    For example:

     

    <Ctrl + H> //Open Find and replace

     

     

    <Alt + N> // Put cursor in the "find what" field

    Type: AIR CANADA

    <Tab> or <Alt + E> // put cursor in the "Replace with field

    Type: AC

    <Alt + A> // Replace All

     

     

     

     

    -=+=--=+=--=+=--=+=-

    For added complexity you can create a text file that is Ascii delimited (I saw that some of your items have commas in the name which will messup any comma delimted files ex:Line 4):

     

     

    File Contents:

    ln1: "Air Canada","AC"

    ln2: "ABB INC.","ABB"

    ln3: "ABB CANADA","ABB"

    ln4: "ALBERTA EMPLOYMENT, IMMIGRATION AND INDUSTRY","AEII"

     

     

    <Ctrl + H> //Open Find and replace

    Ascii File Begin Process

    //T1 Column 1

    //T2 Column 2

     

    <Alt + N> // Put cursor in the "find what" field

    Type: %T1%

    <Tab> or <Alt + E> // put cursor in the "Replace with field

    Type: %T2%

    <Alt + A> // Replace All

     

    Ascii File End Process

  10. That does sound like a great idea, but with macro express I am not sure how it handle the creating on the semaphore.xxx file. I see an issue with two computers identifying that the file doesn't exist and creating the file. I could not genereate an error with two computers creating the same file over and over (using an infinite loop of course). This of course leads both computers into making use of the shared resource.

     

    One thing I am going to try to do with the method is have the computer output its name in the semaphore.xxx file and then wait 1 second for any other computers to finish their operation should the timing be so close that they both try to create the same file. After the 1 second, each computer in the loop will read the file and if its name does not exist in the file it will kick out and wait for the semaphore.xxxx file to no longer exist.

     

     

    Thanks for the Response!

     

     

     

    --Don

  11. So I am running ME on about 7 computers that break apart a process to greatly increase the run time speed. (2 hours for 7 computers or 16 hours + for 1 computer) Its not a direct time relationship due to the system speeds during the day.

     

    I have a file that is read and written too by each macro express on each computer and it directs what processes have been done already.

     

    For example computer 1 would create the file and write the first process it did on line one so (processed 11/23/2009, worked on xyz) then computer 2 would read that file see that another computer created the file and read the file. It then recognizes that (11/23/2009, xyz) was worked and it will output the next process (11/22/2009, ABC) so another computer doesn’t work it.

     

    So that’s the setup for the multiple computers working together, its more complicated than that but that’s not this issue. The issue is locking the file so that when the file is being read it’s only being done by one computer at a time. I do understand that the "read" cannot be blocked unless permissions are changed but locking the file so computers are not all writing at once may get around this issue.

     

    I have tried several different tests with no success.

     

    Things I have tried:

    • Using the "Wait for file ready"
    • making sure the file is ready for 5 seconds
    • This doesn't accomplish much besides making the computers all read and write to the file at the exact same time causing each one to pickup the same task.

     

    • Using the "if file ready"
    • With this I created another file which a computer would open in the ASCII then execute the code to read and write on the task list file.
    • Computers would then see if the "lock" file was ready rather than the task file.
    • This showed much better results and computers didn't double up on processes, however it wasn't 100% in my stress testing.

     

    My last resort is to have each computer rename or move the file so other computers don’t have access to it then move it back when it’s done. I am worried that this will crash any running macros that are trying to access the file at the same time rather then having them wait for it to be ready. This poses other concerns such as other machines thinking the file hasn't been created or the computer that renames it crashing bringing down everything.

     

    Any suggestions would be great, I know there is a lot here but I wanted to explain the situation fully.

  12. Edit: misunderstood the question

     

    Could you run the BlockInput(0) before ME macro 2?

     

     

    although i do not know why you block input for 30 seconds, i assume the macro is running code, you could just block the input for the duration of the code running then run macro two.

     

    BlockInput(1)

    (Do code)

    BlockInput(0)

  13. Let's use Google as an example.

    https://www.google.com/accounts/NewAccount

    You want your macro to enter the text box just to the right of "Your current email address:"

    Use ALT + d and the cursor jumps to the address bar as a universal start point and then *maybe* you can then TAB the same number of times and hit that box every time but in practice it doesn't work very well consistently.

     

    So how would you approach jumping right to that specific text box for entering your current email address? I've spent hours trying to master this problem and still don't have any clue on a 100% effective solution.

     

    Thanks for any input.

     

     

     

    Hola,

     

    Using your example website

     

    You could use the find command (Ctrl + F) in IE. If you were looking for the "Your current email address:" text box, searching for it though Find will Highlight the text next to the box. Then have the macro kill the find window and just hit tab to put the cursor in the text box.

     

    <REM2:-=+=--=+=- Open Website -=+=--=+=-><HTTP2:1:F:https://www.google.com/accounts/NewAccount><WAITWEB2:000010:000000:https://www.google.com/accounts/NewAccount><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Open Find Window -=+=--=+=-><TEXTTYPE:<ALT><ALT>EF><WAITWIN2:000010:000000:Find><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Look For First Text Box -=+=--=+=-><TEXTTYPE:email address:><TEXTTYPE:<ALT>F><WCLS:"CURRENT"><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Enter Text Box -=+=--=+=-><TEXTTYPE:<TAB>Username@gmail.com><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Open Find Window -=+=--=+=-><TEXTTYPE:<ALT><ALT>EF><WAITWIN2:000010:000000:Find><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Look For First Text Box -=+=--=+=-><TEXTTYPE:Choose a password:  ><TEXTTYPE:<ALT>F><WCLS:"CURRENT"><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Enter Text Box -=+=--=+=-><TEXTTYPE:<TAB>MacroExpress!><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Open Find Window -=+=--=+=-><TEXTTYPE:<ALT><ALT>EF><WAITWIN2:000010:000000:Find><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Look For First Text Box -=+=--=+=-><TEXTTYPE:Re-enter password: ><TEXTTYPE:<ALT>F><WCLS:"CURRENT"><REM2:><REM2:-=+=--=+=- Enter Text Box -=+=--=+=-><TEXTTYPE:<TAB>MacroExpress!><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Open Find Window -=+=--=+=-><TEXTTYPE:<ALT><ALT>EF><WAITWIN2:000010:000000:Find><REM2:><REM2:><REM2:><REM2:-=+=--=+=- Look For First Text Box -=+=--=+=-><TEXTTYPE:Word Verification: ><TEXTTYPE:<ALT>F><WCLS:"CURRENT"><REM2:><REM2:-=+=--=+=- Enter Text Box -=+=--=+=-><TEXTTYPE:<TAB>Like I have Any Idea What It Says>
    
    
  14. Hello,

     

    I imported macros from someone else which are password protected. I want to delete these macros from my mex file but it will not allow me to without entering the password. I do not know the password.

     

    How can I delete the macros? Why is this behavior even in place?

     

    Thanks!

     

    Macros cannot delete password protected macros. I get an error saying the macro is locked when i try to do it. I attached my screen shot of the error.

     

    I think the only thing you can do is export all your used macros to a new .mex file then just overwrite the old .mex file too.

    Select the macros you wish to keep then:

    File -> Export -> Export Macros.

     

    Or create a new .mex file and import your macros both ways work :) enjoy.

    post-4204-1248406223_thumb.jpg

  15. Hi All,

     

    We're testing out the 30 day eval copy of Macro Express and so far we really love it. We have several web based surveys that we have to test regularly, and ME seems like it could really help us out with automating that.

     

    Here's my problem: One of the web surveys we test has a question where we need to select multiple answers by holding down the control key and using the mouse to click on all the answers we want to select. When I'm done capturing the macro and replay it, it doesn't replicate the holding down of the control key. Looking at ME help I see that I can insert control key down/up commands in the script, but the script is so long that I have no way of finding where in the script I would need to insert these commands. Is there some setting/preference I could set that would allow capture of the control key by default?

     

    thanks,

    Ed

     

     

    Hi Ed,

     

    To find where you need to put the <ctrl Down> / <Ctrl UP> parts in the macro, you can use a text box to appear at various points in the script. This would help you narrow down where the macro is clicking.

     

    Another way you can minimize code is an option that is located in the Recording screen. Check the "Only Capture Mouse Clicks". I am assuming your code is extremely long because the macro is recording mouse locations with delays.

  16. I am trying to run a hotkey that will copy the value into a variable from a excel cell.. perform a 'IF End' test function and the test function will replace the abbrivation of whatever the variable contains and then write it back to the cell..

     

    Other than my 'AIR CANADA' and BANK OF NOVA SCOTIA' cells, the macro is giving me unpredictable results. There are times where it does replace the cell at all and at times will replace the cell with something that is not even in any of my test conditions. If I open up notepad and highlight the same words and run the macro, it behaves fine. Below is my script:

     

    any ideas would be greatly appricated..

     

     

    You can try hitting the F2 function key which puts the cursor on the inside of the cell. Then just have the macro select the contents, copy and type the resulting information into the cell

     

    Code:

     

    <REM2:Select the Cell><TEXTTYPE:<F2><END><SHIFT><HOME>><REM2:><REM2:><REM2:+=--=+=--=+=--=+=Clip Board Copy+=--=+=--=+=--=+=><REP3:01:000001:000001:00005:0:01:><CLIPC><REM2:><REM2:Wait 1.3 Seconds for Clipboard><REP3:01:000001:000001:00087:0:01:><IFOTH2:07:1:><MSD:15><ELSE><EXITREP><ENDIF><ENDREP><REM2:><IFOTH2:07:1:><REM2:If the wait for 1.3 seconds did not capture anything, reinitiate the <Ctrl + C>><MSD:15><ELSE><EXITREP><ENDIF><ENDREP><REM2:><REM2:Run the IF-End Code here><REM2:><REM2:><REM2:><REM2:><REM2:><REM2:Run the IF-End Code here><REM2:><REM2:Text Type: Resulting Abbrivation>

     

    I use a more advance clipboard copy because every computer (generally) has a different about of time between hitting <Ctrl + C> and when the data actually gets to the clipboard. Without the code above sometimes setting a variable right after a clipboard copy could be blank, depending on the clipboard copy speed of the computer. I think the default for a computer is 250ms :(.

     

    Also I saw a Clipboard Empty in your code, I use excel 2004 and if a cell is copied (has the dots around the cell) clipboard empty crashes excel everytime.

  17. Yes, I wrote and publushed some code a while back that is remarkably similar.

     

     

    Great minds must think alike B)

     

     

    I was just thinking that this problem may not be macro express but the application its typing into. Macro express "types" Ctrl-v very quickly (less than a few milliseconds) and my guess is the application sees this as Ctrl then v. Whereas a user typing Ctrl-v is holding down the keys for longer periods of time giving the application plenty of time to recognize the command.

     

    I am not sure how much the macro is typing out, but if its is a lot of text splitting up the CtrlDown==> V ==> CtrlUp with a very slight delay may allow the program to keep up with sending specific commands.

     

    <TEXTTYPE:<CTRLD>><MSD:5><TEXTTYPE:v<CTRLU>>

     

    I personally wouldn't use this for 10-20 characters of typing.

  18. In my experience, setting a clipboard delay of 0 is exactly the reason why you are getting the problem. generally, Windows clipboard operations are slow and unreliable. Setting ME to one side, I can often select some text and press Ctrl-C (I use ClipMate, so I can hear if the copy has worked). Often, I hear nothing on the first attempt; sometimes it takes me 3 or 4 goes before it "takes". If I experience that manually, what chance has ME got?

     

     

     

    I have a fix for this. I use it as a function because its rather lengthly and pasting this in every time Ctrl + C makes for a long code. I just call the macro below to do all the clipboard coping and T1 is set to the clipboard contents.

     

     

    1. First there is a loop to do clipboard copy 5 times to make sure there is something on the clipboard
    2. Inside the clipboard copy loop is a loop that makes sure something is on the clipboard
    3. If something is on the clipboard the loops are exited and another loop is entered
    4. This second loop makes sure that the variable set from the clipboard is exactly what was on the clipboard

     

    Since windows uses a buffer for the clipboard i have experienced variables only getting half the clipboard, the second repeat fixes this.

     

    <REM2:++==========================================================++><REM2:*-^*-^*-^*-^*-^*-^*-^*-^*-^*-Macro Title-^*-^*-^*-^*-^*-^*-^*-^*-^*-^*-^*-^><REM2:     Macro Title Function: Clipboard Copy (Advanced)><REM2: ><REM2: ><REM2:*-^*-^*-^*-^*-^*-^*-^*-^*-^*-Description-^*-^*-^*-^*-^*-^*-^*-^*-^*-^*-^*-^><REM2:     Macro Description ><REM2:        1.  Initiate the CTRL + C><REM2:        2.  Wait for something is on the clipboard><REM2:        3.  Verify that the clipboard is exactly what was set in the variable><REM2: ><REM2:~`~`~`~`~`~`~`~`~`~`~`~`Author`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`><REM2:.-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨).-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨)><REM2:(¸.-´ (¸.-´ (¸.-` (¸.-´(¸.-´ (¸.- Donald  (¸.-´ (¸.-´-´(¸.- (¸.-´(¸.-´ -´(¸.- (¸.-´(¸.-´-´(¸.-><REM2:.-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨).-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨)><REM2: (¸.-´ (¸.-´-´(¸.- (¸.-´Monpas (¸.-´-´(¸.-´ (¸.-´-´(¸.-(¸.-´ -´(¸.- (¸.-´(¸.-´-´(¸.-(¸.-´(¸.-´><REM2:.-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨).-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨)><REM2: (¸.-´(¸.-(¸.-´-´(¸.- (¸.-´ (¸.-´-´04/17/09 -´ (¸.-´(¸.- (¸.-´ -´(¸.-(¸.-´(¸.-´ -´(¸.-(¸.-´(¸.-><REM2:.-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨).-*´¨) ¸.-*¨) ¸.-´¸.-*´¨) ¸.-*¨) ¸.-¸.-*´¨)¸.-*¨)><REM2:~`~`~`~`~`~`~`~`~`~`~`~`Mods`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`><REM2:     MOD: User Name, Date, Description of Mod><REM2: ><REM2: ><REM2:++==========================================================++><REM2:><REM2:><REM2:><REM2:><REM2:-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-><REM2:                                           Variables><REM2:-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-><REM2:T1: Variable returned with clipboard contents><REM2:><REM2:><REM2:-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-><REM2:                                           Variables><REM2:-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-><REM2:><REM2:><REM2:><REM2:><REM2:5 Attempts to get something on the clipboard><REP3:01:000001:000001:00005:0:01:><REM2:Note: DO Not use Clipboard Empty with Excel 2004, chance of crashing><CLIPE><CLIPC><REM2:><REM2:Wait 1 second (200 repeats 5 millisecond delay) for something to appear on clipboard><REP3:01:000001:000001:00200:0:01:><REM2:Make sure that there is something on the clipboard before continuing><IFOTH2:07:1:><MSD:5><ELSE><REM2:Clipboard has something exit><EXITREP><ENDIF><REM2:><ENDREP><REM2:><IFOTH2:07:1:><REM2:If there is nothing on the clipboard, repeat><ELSE><REM2:Clipboard has something exit the "5 attempts" Repeat><EXITREP><ENDIF><ENDREP><REM2:><REM2:><REM2:Since the clipboard works with a buffer sometimes (very small chance) ><REM2:the clipboard will only half copy to a variable, this loop makes sure that><REM2:the variable is exactly whats on the clipboard><REP3:01:000001:000001:01000:0:01:><REM2:If clipboard is blank there is not point in this loop><IFOTH2:07:1:><EXITREP><ENDIF><REM2:><TVAR2:01:03:><REM2:><REM2:Makes sure that T1 is properly set><IFOTH2:07:1:%T1%><EXITREP><ENDIF><ENDREP><REM2:><REM2:>

  19. I upgraded from 3.7c to 3.7d and I can't set text type delay to 0 anymore. Even if I uncheck it or set it to lower number, it still behaves as the default 300ms. Can this be fixed?

     

     

    You could try the Keystroke speed setting:

     

    <SPKEY:0000>

     

    Just copy that and past it at the top of the macro and see if that remedies it. Its not the ideal fix because you shouldn't need that at the beginning of every macro, but it may work.

     

     

    Another option would be to uninstall 3.7d and do a fresh 3.7d install rather than a 3.7c to 3.7d upgrade install. The registries could be messed up not allowing the defaults to be set. I have some notes on how to changes these using the Macro express registry read/write commands, but I don't have access to them at the moment. I'll post them if there is anything useful.

×
×
  • Create New...