Using Macro Express

Macro Express at Yale Home Page   Oct. 2006

Importing and Running the Series Template Constant Data Macro

1. Start PCAmigo.

  • select View Available Software.
  • click to open the Category List
  • double-click on University Library

2. Scroll down the list of file names and find MacroExpressSAR file.

  • click on the hyperlink Details
  • in the new window, click on the Download icon

3. When the File Download window opens, DO NOT CLICK ON THE SAVE BUTTON. Instead,

  • click on the OPEN button if your operating system is Windows 2000, or
  • click on the RUN if your operating system is Windows XP
  • the black c:\WINNT\system32\cmd.exe window will open
  • press ENTER; the window will close and you can now close PCAmigo

4. Open Macro Express. If the Macro Express icon is in the start tray, double-click on the icon. If it is not, start the program: Start-->Programs-->Macro Express-->Macro Express3.

5. Assuming your current Macro Express file is up to date, your default Macro Express file should have on the title bar:

If you have a different path listed, consult with your expert user. Some units use a different master file; in that case, it is OK to continue. On the other hand, if your unit is supposed to be using the standard master file, you should change to the current version before continuing.

6. Create a new Category Folder.

  • place the cursor on ALL Categories (just below Categories)
  • right click and select New Category
  • in the prompt box, type Connexion; a new folder [Connexion] will appear under Categories

7. Select the Connexion folder. Macros area should be blank.

  • Click the Import Macro icon on the Toolbar

  • The import window will open. Click on the Open File button.

8. A window will open. Check Look in: and verify that the folder is Macro Express3. If it is anything else (such as Attachment or My Files), use the Look in: scroll bar or the Up One Level icon to navigate to: c:\Program Files\Macro Express3. NOTE: the Macro Express3 folder for most catalogers will usually have only around 4 files.

  • Find the SAR.mex file and double click on the icon or click on the Open button

9. The SAR macro will now be listed in the Import File window.

  • select the macro (left click)
  • click on the Import button.

  • The import complete window will open. Click OK.

  • Click Exit on the Import window to close.
  • When the Macro Express import window has closed, the Macro Express Explorer window will look like this:


  • The import is now completed.
  • Close the Macro Express window. (This does not close the program; the icon should appear in the Start tray)

10. To run the macro,

  • Connexion window must be on top (the macro will only run with the Connexion window on top)
  • Hold down the control key and the s key and let go.
  • The macro will open the blank template, find your default Constant Data template and overlay the template on the blank template
  • You are now ready to enter text and, eventually, to save the record.


Site URL:
Last revised: October 25, 2006 , 2006 Yale University Library
For information on other Yale cataloging policies and procedures, go to: Cataloging at Yale