nmanager

Thanks Stan, I'm not sure the options in the article will help, but I will keep trying. The Get Pixel Color command may work. There is no check box. However, the "Options" box is in a different location depending on the state - active/inactive. The two states of the windows are shown in the attached picture. The problem with this option is the box may pop up in different areas of the screen on different size/style monitors.

Anyone know how to tell which way an option box in an Excel window is toggled? Specifically, in Excel 2003 the CTL +F window (find) has an option box and I can't tell which way it is toggled. I tried the Get Control, but the window shows up as all the same control. Thanks for yor help in advance.

Timing seems to be a big issue in a macro we are using and the Keystroke Speed and Macro Playback Speed controls seem to be the fix. However, something is wrong. Using Integer Variables 98 and 99 to control the keyboard and playback speed - Keyboard 200 milliseconds and playback factor 3 <IVAR2:99:01:200><IVAR2:98:01:3><SPKEY:%N99%><SPEED:%N98%> This appears to work okay in the "main" part of the program, but when I use <SPKEY:%N99%><SPEED:%N98%> in a called program (MACRUN2:) the Integer Variables 98 and 99 are passed into the called program, but there is no effect on the keyboard or playback speed. What am I doing wrong?

Try the program using lower case letters. I had problems using upper case letters in Excel because ME looks at capitals as a SHIFT UP command.

Can a wildcard be used in Modify String Variable/Replace Substring? If so how? Looking to remove the year from a string - 12/2008 to just 12. Tried to remove /* and /? but they do not work. Can't just move over 2 characters because there is no leadng 0 on single digit months - 1/2008. Can replace / with a few blanks, then delete part of text, then trim, but looking for something a little "cleaner" Thanks

Thanks Cory, the "extra" line feed was the problem. It is printing on one line now. It is a good feature to know about and will come in handy on Excel.

When I paste from the clipboard into a cell, it pastes text up to a variable then drops down to the next cell and pastes the rest of the text. In the example below: T35 = Jun T3 = %35% Rev = Jun Rev "Jun" is printed in one cell (A1) and "REV" prints in the cell below it (A2). It is all supposed to print in one cell (A1) <TVAR2:03:01:%T35% Rev><TMVAR2:16:03:00:000:000:><CLIPP> Another clue - when this is run as a standalone macro it puts all in one cell. When it is part of the macro I am working on, it puts it in two cells. The same code with two different results! Jun Rev vs. Jun Rev Win 2000/Office 2000

Stan, After a night of sleep my eyes are not a blurred as they were yesterday. Your idea not only helped with my problem, but has lead to a better understanding of how ME works. The direct editor is not as bad as it looks! Thanks again for the help.

Stan, Thanks for the help. Just did the export. Not sure if I can use the file, it is very messy. May not be to someone used to working with data dumps, but it made my head hurt. I use the scripting editor. Any other suggestions?

How do we search all macros to find text or variables within the macros? I have a main macro that calls out 35 sub macros in sequence. Now I need to find some variables to see which macro(s) use them and would also like to search for specific text. SEARCH appears to look at the Macro Nickname only, not in the text of the macro. Opening each macro and searching takes too long. Even if each macro was fully documented, it would still take too long to open and search every macro. The macros are all in the same file and show up in the main window. Thanks for any help you can offer.

Thanks everyone. I went with Cory's dual box option. The main macro now calls out a sub-macro that contains a dialog box and the IF MESSAGE box. The dialog box with the check list items inside opens first. Then the IF MESSAGE box opens so both boxes are open at the same time. The dialog box in the sub-macro is set to close when the sub-macro ends, so both boxes close at the same time. All nice and easy. Paul, the add on program is nice, but there were too many IT red flags. I would not be allowed to use it. It says in the instructions, "It's a very ugly system hack that sits in your system tray...This small hack is completely and utterly free and we accept no responsibility if it causes something to misbehave! It -=IS=- a HACK! "

How do we change the size of a Dialog Box? I am using IF MESSAGE to show a checklist with OK/Cancel option before running a Macro. Only part of the text shows on the screen. Also, how do we change the font size/color/etc. in the dialog box. BTW can't search the forum for "Dialog Box" because box is only 3 letters. Thanks.

This may not be documented where it can be easily found and may be helpful to other new users. The use of capital letters when entering text can lead the program to think you have pushed the SHFT key. This was messing me up for hours when using ALT to access the menu bar. ALT F drops down a totally different menu than ALT f. Same thing with ALT E and ALT e. I am using Win 2000 and Office 2000.

This works great. Can a wildcard be used for the tail end of the filename? I have many files that need the same macro. All the files start with "Forecast" and then have business units and dates as the rest of the file name before the ".XLS". Only one file will be open at a time. It would be nice not to have to type each file name in. Yes, the microwave is too slow for me...