stan

Nick, Here is what I would suggest. Use the Alt + d to highlight the URL line. Copy to the clipboard and then use the If Clipboard command to see if you have the correct tab open. If not, press Ctrl + Tab to go the next tab and repeat the process until you find the right one. Or you could set it up in a Repeat loop. Save the clipboard to a text string variable and Repeat Until the variable matches the URL you want. This way it wouldn't matter how many tabs you have open.

I guess I don't understand. The macro I described will process all 150 lines of the .csv file. After it has finished, do you want the macro to repeat the exact same steps for all 150 lines?

The ASCII File Begin Process command will do this for you. It reads the first line of the .csv file and saves each record (cell) to individual text string variables. You can then have the macro enter each variable into the appropriate field on the form and save it. After these steps insert the ASCII File End Process command. The macro starts over again with the second line of the .csv file, repeating the steps. When finished it starts with line 3 and so on until every line in the file has been processed.

Here is what I would try first. Write a simple one line macro to type text or display a message. Test the macro and see if this runs on her computer. If it doesn't then another application running on the computer is most likely blocking the hooks. You already tried the Restore Keyboard Hooks option. Try restarting Macro Express and then test a macro. If this fails, look at other applications running on the computer, especially those that run in the background. It could be that a setting to a firewall or anti-spyware program needs to be changed. Try closing down applications one by one and test Macro Express after each program closes. If your new macro did work, then check the scope on your original macro. Set it to global and try the macro again.

Hi, Here is a sample of how I would approach this. <TVAR2:01:02:FFFCenter:Center><TMVAR2:14:01:00:005:000:><TMVAR2:21:01:01:000:000: 0> You first need to save the number to a text string variable. This example just uses the Variable Set String - Prompt for Value command. The next step uses the Variable Modify String command to pad the string. The last step also modifies the string, Replace Substring. In the Text to Replace field press the Space Bar once. In the Replace With Field enter zero (0). Check the Replace all Instances box and save. So if you set the pad string option to 5, the macro will insert 4 zeroes if the original number is only one digit. If two digits, then 3 zeroes are added, etc.

Here's what I would suggest. Use the Program Launch command. Click on the Browse button next to the Program Path / Name field to open the Browse for an Executable window. Change the files of type field to All Types. Browse for the file that you want to open and save. This will open the program associated with that file type and the file. For example if you are opening a .txt file, most likely it will open the file in Notepad. A .doc file would open in Word, etc. If you need something different, then browse to the .exe file. In the program parameters field enter the path to the file to be opened by the .exe. Enclose the path in quotes.

I think basing the mouse position on the window size is your best bet. If the window opens in different sizes, you can use the Window Resize command to standardize the dimensions each time the macro is run. To click on the button, use the Mouse Move command. Open the Mouse Locator to help you find the X and Y coordinates. Set the movement to Relative to Window. After moving the mouse, use the Left Button Click option to click on the coordinates defined.

The Variable Set Integer %N2% from Left of Window command finds the position of the left side of the window. The Variable Set Integer %N3% from Top of Window finds the position of the top of the window. Based on your screen dimensions and knowing what the size of the window should be, you can determine if the window is in the lower left hand corner. Use the Variable Modify Integer command to do the math. If there are no other windows displayed on the screen you can try using the following two commands: Variable Set Integer %N1% from Width of Window and Variable Set Integer %N2% from Height of Window These will give you the dimensions of the current window. You can tell if the window is maximized or standard size based on the dimensions by using the If Variable command. A minimized window provided odd values. But it seemed to provide the same values every time for each window I tested. The odd values should let you know if the window is minimized. You willl need to experiment with the window you are using to see what values are saved when minimized.

Yes, Macro Express will do this. Use the Repeat with Folder command and save the file name to a variable such as T1. Then use the Variable Set from File Path command to save the file extension to a variable such as T2. Enter %T1% in the Filename/Path field if you saved the file name in the previous command to T1.

Welcome to the forum. Is there any way to get this information manually, without using Macro Express? Can you highlight the text from the menu and copy to the clipboard? Or somehow grab the information another way? If you cannot do this manually, then I don't see a way for Macro Express to extract the information. If you can, how are you doing this and we'll see how Macro Express can replicate the steps.

Ok, I see what you are trying to accomplish. One option would be to use the Variable Set Integer command to grab the height of the Find window and save to a variable such as N1. Then run the If Variable command to find out which version of the window is open, based on whether or not N1 is greater than the size of the standard Find window. Or you can use Get Pixel Color option. Find a spot on the expanded window that has black text, but does not in the smaller window. Grab the pixel color and get the position relative to the window and not the screen. This way it doesn't really matter where on the screen the window is located. It looks for the pixel based on the number of pixels down and to the right of the upper left pixel in the window. Then use the If Variable command as mentioned in the article.

If I understand correctly, there is a knowledgebase article that describes what you want to do. The article title and URL are listed below. How can I determine the state of a checkbox or radio button? - http://www.macros.com/faq//1.49.html

Welcome to the forum. You can password protect the Macro Express Explorer window. To do this, click on Options | Preferences | Passwords. Select the Password on Edit option and set the password. Anyone trying to open the Explorer window would need to first enter the password.

GHC did contact our support group on this issue. Since we have had several others report a similar problem, I thought I would post the solution on the forum also. It sounds like the Text Type window is popping up underneath the Macro Explorer window. Try shrinking the Macro Express window and then click on the Text Type command. Move the Macro Express window if necessary to see if you can find the Text Type window. Or try pressing Alt + Tab and cycle through the windows to see if you can get the Text Type window to pop up.

Here's what I would suggest. First save your Excel file to a .csv format. Then use the ASCII File Begin Process command. This runs your macro in a loop. It starts with line 1 and saves the contents to a variable such as T1. Do what you need with the variable and close with an ASCII File End Process command. This closes the loop and the macro starts over with line 2 of the .csv file and so on. The Help topic for this command explains the process in more detail.

Here are a couple of things to try. 1. Down arrow once to the item below and then up arrow back to your selection. Does this give proper focus so that you can copy to the clipboard? 2. Many of these type menus allow for a right mouse click and a Rename option. If this menu allows, choose Rename and then copy to the clipboard.

The Web Site command is going to open a new tab or new browser window, depending on your version of IE, each time. I would suggest having the macro activate the IE window, if it does not already have focus. Then press Alt + d to go to the address bar. Then have the macro insert the new URL and press enter.

Maybe you can try a reverse approach using the If Window Not on Top command. If your window is not on top, then this should mean that the msgbox is on top. Take the logic from there. Or you may be able to use the Window Controls commands to save the msgbox to a control variable. Then use the If Control commands for the logic.

I'm not aware of a way to do this with Macro Express.

Macro Express 3 should have installed into a Macro Express 3 folder, which is different from the Macro Express 2000 location - unless you specifically instructed the program to install over top of the older version. In any case it should not have deleted your old macro file. Open Macro Express 3 and click on File | Open Macro File. Navigate to c:\Program Files\Macro Express - the default install location for Macro Express 2000. Look for any .mex files in this folder. If found, select the file and you will be prompted to convert the file to the newer file format. Once converted it cannot be changed back to the older format and read back into Macro Express v2. You can make a backup copy of the file if you want before converting. If the folder does not exist, then do a search on the computer for *.mex to find any macro files on the computer. When found, load in the file. The only problem we have encountered with the 64bit version of Windows, is recognizing 64 bit application window titles. Macro commands that use a window title, such as Wait for Window, Window Activate, etc. will not work with 64 bit application windows. If the application is a 32 bit program, then Macro Express will work correctly.

Cory, If I understand correctly, I would suggest a low-tech solution. Have the macro open the message into a separate window. Highlight the message and press <Enter> should do it. Once the window is open, press Tab once to move to the From field. Another Tab moves to the Date field where you can grab the information. Tab through the To and CC fields to the Subject and grab that information. I can't think of any other fields that would be inserted to mess with the Tab order. But maybe that's what you're running into, so you're looking at Controls instead. The above works for Outlook 2007. Shift Tab works with Outlook 2000. This starts at the bottom with the subject. Shift Tab in 2007 will not work if there are file attachments. The focus first goes to the attachment in 2007.

It sounds like you would want to use the Text File Begin Process. This file reads the first line of the file and saves to a variable. Do what you need with the variable and close the loop with a Text File End Process command. The macro then loops back and reads line 2 of the file, and so on until the end of the file. The help topic explains this in more detail.

For the Windows "Select All" function you would use the Text Type command to look like this: TEXT TYPE: <CTRL>a This holds down the ctrl key while the "a" is pressed. Use a lower case "a", otherwise it will be interpreted as Ctrl Shift a.

If I understand correctly what you are trying to do, here is what I would suggest. Place the .pdf file names in a .txt file. Use the Text File Begin Process command to read the first file name from the list and save to a variable such as T1. Use the Text Type command to open the file saved to T1. Set an Integer variable such as N1 to 1. Save the file as pg%N1%.ai which translates to pg1.ai. Increment the value of N1 so that it is now 2. The process repeats with the second file name in the list and saves the file to pg2.ai. Below are the basics. You will need to fill in the functions to open the file, open the save as dialog, etc. Text File Begin Process: "pdflist.txt" Text Type: %T1% Variable Set Integer %N1% to 1 Text Type: pg%N1%.ai Variable Modify Integer: Inc (%N1%) Text File End Process

I just tried a simple experiment and it seems to work. After opening the browser the first time, use the Text Type command to press Alt d. This takes the cursor to the address line. Then have the macro type the URL in the address line and press enter to open the new page. Follow with a Wait for Web Page command.