jason

Macro Express Pro v 4.1.5.1

Macro Express Pro v 4.1.5.1 has been released and is now ready for download.

For more information, including a description of the recent changes to Macro Express Pro, please see our Revision History on our website. A newsletter will be released soon which will cover the changes and give more hints and tricks.

The latest version of Macro Express Pro may be downloaded from the Macro Express download page.

We are aware of this issue and have fixed it. The fix will be part of the next release of the program.

The more reports we have, the better we are able to track down the actual cause of the issue, so it is preferable to have multiple reports of the same crash. Sometimes issues that seem to be the same problem are actually multiple issues while one issue may cause several different problems across the program. Once we receive the reports, we will associate them together in our bug tracking software so when the issue is fixed, you should only receive one notice instead of multiple notices.

It depends on the type of drop down menu. Here are some different methods depending on the type of drop down:

Type out the first few letters of the word. You would need to type alab to get Alabama.

Type the first letter of the word several times. Type A four times to get Arkansas.

Type the first letter and then the down arrow button. Type N once and then the down arrow 3 times to get to New Jersey.

Unfortunately, drop downs menus, like other controls, are controlled by the operating system and so there is not really a way to alter their performance.

You can set up a cell or column to allow leading zero's by clicking on on Format > Cell. From Format Cells window, click on Custom in the category list. You can then set the cell up to allow leading zero's. You can find formatting information in the Excel Help by searching 'leading zero'.

I used the Move File/Files command to move the folder. I have uploaded a screenshot of the settings used. This completely moved the folder. No folder was left on the C drive named Development.

You can move a folder by using the Move File/Files command. Just don't specify a specific file in the path for the file to be moved.

e.g. Move File/Files: C:\Program Files\TestFolder

instead of

Move File/Files: C:\Program Files\TestFolder\TestFile.txt

The title bar cannot be turned off. This is so that there is some part of the window to grab onto to move the menu when necessary.

The file mxe is correct. MEX is the file extension for macro files and MXE is the extension for a playable macro.

As no errors are displayed, it sounds like the macro is running. You could test this by placing a Text Box Display command in the playable macro. If it appears, then you may want to check the file paths that are being used in the playable macros to make sure that nothing has been moved or changed.

The decision was made to skip comments to help optimize the macro. Less lines = less execution time.

When running the debugger in the scripting editor, comment lines are ignored as they are not real code. This means that the line is completely skipped and never checked for a break point.

You are correct. This is no longer possible. You can however, make a copy of the macro and set it to popup. To do so, make a copy of the floating menu macro and then check the option to build as a popup menu when selecting the new activation.

Unfortunately, there is not an official list. Some users may have created their own however.

I can't think of a way to password protect a text file. However, you could use the File Attribute command to mark it as read only. This would allow them to look at it, but not modify it unless they go into the properties and remove the Read Only flag. This is not a true solution, but more of a deterrent.

You could also use the File Attribute command to mark the file as hidden. Again, not a true solution, but it would hide the file unless they have the Show Hidden Files option selected in their File Explorer.

3.7d is the latest version. We have not written or released version 3.7e.

We tried it here without any problems. There are a few things to watch out for when running scheduled macros.

1- A macro cannot run when the computer is locked.

2- A macro cannot run if a screensaver is active. You can disable the screensaver by clicking on Options | Preferences and then selecting Scheduler from the list on the left. Check the box marked "Disable Screen Saver when using Scheduled Macros. (Note: This will only work if you have the proper permission to change these settings from your network administrator).

3- Currently, only one macro can run at a time. If another macro is running, the scheduled macro may or may not activate.

Some users have been successful using the Get Pixel Color command. You can do this by getting the pixel color of the progress bar found in the Status Bar at the bottom of the browser program. Usually the color of the bar is blue or green depending on which browser you are using. Just set up a loop to get the color. You can then check the color, if it is still green or blue, have the loop repeat, if it does not equal that color, than the page has loaded and is ready.

Get Pixel: Screen Coords: 1011,877 into %N1%
Repeat Until %N1% <> 3265326
 Delay 300 Milliseconds
Repeat End

Unfortunately, Macro Express does not have a command that will change the mouse cursor.

Try using the Mouse Move command. One of the options is Relative to Control. Once you move the mouse, follow it with a Mouse Left Button command. If this is a web app, you may need to place a small delay between the Mouse Move and Mouse Left Button commands.

You can use an Integer variable to insert the number. Depending on how the macro is run, you may need to save the variable to a text file as well for the next run through.

Variable Set String %T1% from File: "filename"
Variable Modify String: Convert %T1% to integer %N1%
// Place code here to print and type integer value
Variable Modify Integer: %N1% = %N1% + 1
Variable Modify Integer: Convert %N1% to text string %T1%
Variable Modify String: Save %T1% to Text File

The above code will load a variable from a text file, convert it to an integer. After your code has run to print the file, it will add one to the integer value, convert it back to a string and save it to the text file for the next time the macro is run.

You will need to create the text file before creating the macro. The file needs to be saved as a Text file and contain the number you wish to begin with.

There are a couple of ways to get the font color using the Get Pixel Color command. Both options require you to save the value to an integer value. To do so, select the variable that you wish to save it to at the bottom of the Get Pixel Color command. To view the value for testing purposes, you could insert a Text Box Display command with %N1% in it. This will allow you to view the color to insure that it is working properly. You would then need to insert an If Variable Equals command to determine if it meets your criteria or not. From here, you can tell it what you want to do if it does, or does not, equal the color you are searching for.

The two options in obtaining the pixel color are Underneath Mouse, or At Specific Coordinates. The Underneath Mouse option would require you to use the Mouse Move command to place the mouse in the correct position before capturing the color. The Specific Coordinate option requires you to know the exact coordinates. If you are unsure of the coordinates, you can use the Mouse Locator by pressing the Launch Mouse Locator button on the Get Pixel Color window.

You can use the Variable Get Control Text found under the Window Controls commands. Using this command will allow you to copy the contents of %C1% to %T1%. This will then allow you to run the comparison.

Without using the custom application, it is hard to say for sure, but if it uses standard Windows protocols, you should be able to tab from field to field using the Text Type command. Once you have moved to the new field, you can copy the contents to the clipboard and then set a variable from the clipboard.

I would try something like this:

ASCII File Begin Process: "TestFile" (Comma Delimited Text )
 If Variable %T1% = "A"
   Variable Set String %T99% "%T2% %T3% %T4%"
   Clipboard Append Text: "LogFile,txt"
 End If
 If Variable %T1% <> "A"
   Variable Set String %T99% "%T2% %T3% %T4%"
   Clipboard Append Text: "ErrorLog,txt"
 End If
ASCII File End Process

I have also attached a copy of the macro for you to look at.

Also, I have set the macro to bypass file existence checking for these files as they are just examples. I would recommend using this unchecking this option when using these commands in your macro.

Log_File_Not_Equal.mex

Also, if you remember additional information after you post your questions, use the edit option instead of replying to your own post if no one else has replied to it. Many people will see that a reply has been posted and will ignore the post making it harder for you to get your answer.