Jump to content
Macro Express Forums

polishmafia

Members
  • Posts

    12
  • Joined

  • Last visited

Posts posted by polishmafia

  1. Thanks for the reply Kevin.

     

    I will send the error logs to you guys.

     

    I was taking a closer look at the macro log file yesterday, and using my amazing powers of logic and reason :P I think I realized my error with the macro.

     

    At the end of the macro, if certain criteria are met, the macro calls the "Run Macro" command. These criteria were met over and over again, so the macro log file looked something like;

     

    12/27/2006 9:41:53 Macro "Conversion" Started

    12/27/2006 9:41:59 Macro "Conversion" Started

    12/27/2006 9:42:05 Macro "Conversion" Started

     

    ..only repeated 700 times.

     

    Once the criteria was not met;

     

    12/27/2006 13:51:56 Macro "Conversion" Completed

    12/27/2006 13:51:56 Macro "Conversion" Completed

    12/27/2006 13:51:56 Macro "Conversion" Completed

     

    But no where near 700 times. I think the computer simply ran out of useable memory.

     

    We've changed the macro to run on a repeated loop WHILE certain criteria is met, instead of using an IF/ELSE statement.

     

    So far it seems to be ok *crosses fingers* :)

  2. If you want to manually stop it in the morning, then thats easy.

     

    Just use a general repeat function. Repeat until N1 = 0, and at the end of the macro set N1 = 1. That way it will never hit zero.

     

    Then in the morning, right click the little running man icon in the task bar. That will stop the macro.

  3. Well there are other ways to do it, but we need more info about what you are having the macro do.

     

    If you need the macro to repeat only 50 times overnight, put that into a Repeat statement with pauses at the end of every macro run, and increment your counter.

  4. I don't know if this is the best way, but this is how I've done it in the past.

     

    Use whatever variable names you want, I'll use N1 for the example. You will need to set your computer to military time for this to work BTW.

     

    - Set variable N1 to the current hour.

    - Repeat while N1 > 8.

    ...have your macro run and run again

    ...set N1 to current hour again at the end, but inside the end repeat.

    - End Repeat

     

    So, you would start the macro at 16:00, N1 would be 16. the next hour it would be 17. once it got to 1am, it would be set to 1, 2am = 2, all the way until N1 hits 8am = 8.

     

    The macro would stop.

     

    HTH

  5. Hello,

     

    I am running a macro that takes all Word documents in a folder, and converts them to PDF. The macro should run continuously all day, every couple of minutes.

     

    The macro seems to run for approx 2 hours, then ME crashes entirely, and the log file shows;

     

    C:\Program Files\Macro Express3\MacExp.exe
    
    12/27/2006 13:15:09
    -EDITED ONE LINE OF INFO-
    Windows 5.01.2600 Service Pack 1
    Windows XP
    -EDITED 2 LINES OF INFO-
    
    EStackOverflow
    Stack overflow
    0x77D8D315

     

    the last entries in the file are;

     

    [00429D48]
    [0046EB57]
    [00455719]
    [0041EEA0]
    [004346B4]
    [0046E7D4]
    [00429D48]
    [005D1F1A]
    [0045B9DF]
    [0045BA16]
    [0045BC36]
    [005F2A2B]

     

    I am stumped. My guess for now is to clear all variables after the macro runs. There are 5 variables, some integer and some decimal.

     

    Can anyone shed any other light on this one?

     

    Thanks in advance!

  6. I am looking for a way to change the destination print of a Word document.

     

    Basically I am trying to do this;

    -Open the word document and print a paper copy to the default Windows printer.

     

    -Wait for the print to complete, then print again to PDF writer - without changing the default printer within Windows.

     

    I have tried opening the print dialog box, and using tabs, arrow keys, etc to select the PDF writer, but there is a slight problem.

     

    Multiple people in multiple locations will be using this macro, and everyone does not have the same amount of printers listed.

     

    Any ideas on how this can be done?

     

    Thanks in advance!

  7. Hi everyone.

     

    I just joined this forum today, and have been using MacroExpress for a few months off and on. I tried searching for my answer, but I'm not exactly sure what I should be searching for :(

     

    The macro I am currently working on asks the user for a variety of string inputs, all via the Set String via Prompt.

     

    One variable the macro asks for is the person's name. Is there a way I can limit the input box to 15 characters max?

     

    I thought of trimming the string starting at position 1, and trimming everything else past 15 characters. I would prefer to have MacroExpress not let the user type in more than 15 characters.

     

    Any ideas? Thanks in advance!

×
×
  • Create New...