"macro Stop" Without The "macro Aborted" Pop-up

[IceBox]

I have a macro that runs every evening on a scheduled activation. It opens 4 different Excel files, copies info from them, and enters them into a database. Using a "Repeat Until" command, the macro runs down every line in each spreadsheet, until it recognizes it has reached the end. That file is then saved and closed, the next file is opened and the process is repeated. After the last file is completed, the file needs to be saved and closed, and the PC rebooted. Here is where my problem comes in...

 

I have a different macro for each of the 4 files. When macro 1 recognizes that file 1 is done, it calls Macro 2, etc. After the "Reboot" command in Macro 4, I have entered a "Macro Stop" command so it does not return to Macro 3, 2, and 1, and continue playing back the rest of the script. However, this causes a pop-up that says "Macro 'xxxxxxxxx' has been aborted", therefore not allowing the PC to reboot on its own until somebody clicks the OK button. Any suggestions on how to get around this?

[joe]

Hello IceBox!

 

Because this is a common question I thought that I would take the time to place an excerpt from the Macro Express Explained book here that covers this subject:

 

--------------------

 

There are certain features about Macro Express that you may want to change, such as the ShortKeys punctuation characters, the "Macro Aborted" message, and so forth. You can change them, but not through the (Options | Preferences) dialog. Instead, Insight Software Solutions has a playable macro utility named TweakMe3.mxe that is available free from their web site. It allows you to change settings stored in a special key in the Registry. Note that it is an unsupported utility meant to be used at your own risk. Personally I have not had any problems using it.

 

If the (Options | Preferences | Miscellaneous | All Users Use the Same Settings) checkbox is checked, and if the currently logged in user has read and write privileges to the HKEY_LOCAL_MACHINE area of the Registry, these advanced options are stored in:

 

HKEY_LOCAL_MACHINE\Software\Insight Software Solutions\Macro Express\AdvOptions

 

Otherwise they are stored in:

 

HKEY_CURRENT_USER\Software\Insight Software Solutions\Macro Express\AdvOptions

 

Here is a short description of each advanced option. Download the macro and read through it to learn more, and to also see some advanced macro programming techniques.

 

Online Delay

The If Online command enables you to test if you are connected to the Internet. As a default, it will wait 5 seconds for a response, then time-out. This option allows you to change the wait time.

 

Activation Prefix

Determines whether to display the words "Window:" or "ShortKey:" in the Activation column of the Macro Explorer window. It affects only the two activation types. The default (setting the value to "1") is to display the words with the ShortKey name or Window title. You can change this to "0" and display the ShortKey name or Window title by itself.

 

Scope Prefix

This is similar to the Activation Prefix. It determines whether to display the words "Program Specific:" or "Window Specific" in the Scope column of the Macro Explorer window. This affects only the two scopes. The default (setting the value to "1") is to display the words with the Program name or Window title. You can change this to "0" and display the Program name or Window title by itself.

 

ShortKey Punctuation Chars

Specifies which characters are used to activate a ShortKey macro when Use Suffix Keys and Use Punctuation Chars are checked in the (Options | Preferences | ShortKeys) dialog. This affects the keys listed in the Suffix column of the chart in the ShortKeys section of this chapter. By default Macro Express uses ! " ' ) , - . : ; ? ] and ` If you specify the list of punctuation characters to use then you must specify every character you want to use, not just additional characters.

 

ShortKey Invalid Chars

Specifies which characters are invalid as part of the ShortKey activation sequence when Use Prefix Keys is checked in the (Options | Preferences | ShortKeys) dialog. This affects the keys listed in the Prefix and Name columns of the chart in the ShortKeys section of this chapter. By default Macro Express uses ~ ( | { } [ and : If you specify the list of invalid characters, you must specify every invalid character, not just additional characters.

 

Macro Stop Abort Message

Hotkey Abort Message

Right Click Abort Message

These options specifies whether the "Macro Aborted" message is displayed when a Macro Stop command executes, or when the Abort Macro HotKey is pressed, or when you right-click on the Running Man icon in the System Tray. All three choices are handled separately, but the default setting for each is "1", which is to display the message.

 

The Macro Stop command will not display the "Macro Aborted" message from any top-level macro no matter how this advanced option is set. It will only display the message from a lower-level macro, which is any macro run from another macro using the Macro Run command.

 

Display Gradients

Determines whether to display gradient colors the header bars in the Macro Explorer, Scripting Editor, and Direct Editor windows. The default setting is "1", which is to display the gradient.

 

Macro Priority

This integer value specifies how much time that Macro Express is allowed to use your computer's CPU/processor. The allowable range is 0 through 2,147,483,647. The default value is 1,000. Zero turns this feature off, which gives full priority to Macro Express. You will need to enter a "-1" in the dialog to turn it off, which is then converted and stored as a zero. A "1" gives the lowest priority to Macro Express. The higher the number the more priority is given to running your macros and conversely for the lower the number. Experiment with caution!

 

Show Pixel Color in Hex in Mouse Locator

This displays both the decimal and hexadecimal value of a pixel color on the screen within the Mouse Locator tool.

 

Add a REG_DWORD named MSLocate Hex Color to whichever key the advanced options are stored. Give it a value of "1" to turn this feature on and a value of "0" to turn it off.

 

Banker's Rounding

There is another advanced feature that is not displayed in the TweakMe3 dialog which affects decimal rounding. Macro Express defaults to a method called asymmetric arithmetic rounding; however, it can be changed to banker's rounding. Add a REG_DWORD named Bankers Rounding to whichever key the advanced options are stored. Give it a value of "1" to turn this feature on and a value of "0" to turn it off (asymmetric arithmetic rounding on). For more on these two types of rounding, please refer to the Round section within the Variables chapter.

[IceBox]

Thanks Joe! Now I feel really dumb LOL! I have a copy of your book sitting right next to me on my desk. Maybe I should have reached over and opened it!