1 / 35

Time Saving Shortcuts with Macro Express

Time Saving Shortcuts with Macro Express. Greg Sennema Electronic Services Librarian Wilfrid Laurier University Session 1912. what are macros Macro Express why use macros workflow of a macro is Macro Express necessary? Macro Express resources. What are Macros?.

lamontk
Download Presentation

Time Saving Shortcuts with Macro Express

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Time Saving Shortcuts with MacroExpress Greg Sennema Electronic Services Librarian Wilfrid Laurier University Session 1912

  2. what are macros • MacroExpress • why use macros • workflow of a macro • is MacroExpressnecessary? • MacroExpressresources

  3. What are Macros? A macro is a way to automate a task that you perform repeatedly or on a regular basis. Macros are script files that send keystrokes to your keyboard and move and click your mouse for, or instead of you. It takes time to become accustomedto creating and using macros

  4. What are Macros? Macros are not just shortcuts. e.g., CTRL-ALT- W = Microsoft Word

  5. What are Macros? Macros are not just shortcuts • CTRL-A – select all • CTRL-C – copy • CTRL-F – find • CTRL-X – cut • CTRL-V – paste • CTRL-S – save • CTRL-P – print • CTRL-O – open • CTRL-W – close • CTRL-Y – redo • CTRL-Z – undo

  6. MacroExpress3.5 If it can be done with a keyboard and mouse… Do it with MacroExpress • runs on Windows XP, ME, 2000, NT 4, 98 or 95 • $25 - $40 depending on quantity of licenses No prior programming experience is required

  7. MacroExpress– Why use Macros? • More time spent on higher-level activities and less on repetitive pointing and clicking and dragging and dropping tasks • More consistent execution of work flow • Potential transfer of tasks to lower-level staff, e.g. student employees • TUG example

  8. MacroExpress– Why use Macros?

  9. MacroExpress– Workflow of a macro • identify the process • look for repetition • reorganize process elements for better execution • consider alternative ways to complete same task • determine necessary information e.g. input from user

  10. MacroExpress– Workflow of a macro • Define the starting and ending points • e.g., within an ILS system, retrieve Bib record by Bib ID • Starting point: display the BIB ID search screen • Note what has to happen for process to work • Note the buttons that are clicked • Note the keys that are pressed • Ending point: display of the bib record

  11. MacroExpress– Example #1 of 4 • Example – Hélène • Starting point: starting an email message • Open “Find” utility • Search for “h-e-l-e-n-e” • Find an email with her name, copy name • Open new email, paste her name • Ending point: having Hélène spelt correctly in email

  12. MacroExpress– Workflow of a macro • identify the process • look for repetition • reorganize process elements for better execution • consider alternative ways to complete same task • determine necessary information e.g. input from user

  13. MacroExpress– Example #1 of 4

  14. MacroExpress– Example #1 of 4

  15. MacroExpress– Example #1 of 4 • Example – Hélène • Similar to Microsoft Word’s Auto Correct feature, • except that this works in ANY program running on • Windows • use short-forms for often-used long words • IE7 = Internet Explorer 7 • MS = Microsoft • ME = MacroExpress • LL = Laurier Library

  16. MacroExpress– Example #2 of 4 • Example – Opening a password-protected web site • Starting point: open browser • navigate to web site (bookmark, address bar, etc.) • place cursor in id box, type in id • place cursor (tab?) in password box, type in password • click on enter • Ending point: logged into web site

  17. MacroExpress– Example #2 of 4

  18. Macro Express – Example #2 of 3

  19. MacroExpress– Example #3 of 4 • Example – Open program, initiate function • Starting point: open Juice • click Start, Juice • click on “check for new podcasts” button • close program when complete • Ending point: mp3’s downloaded into C:/podcasts

  20. MacroExpress– Example #3 of 4

  21. Macro Express – Example #3 of 4

  22. MacroExpress– Example #4 of 4 Example – Process Swets invoice, GST Starting point Ending point

  23. MacroExpress– Example #4 of 4 Ending point Starting point

  24. Macro Express – Example #4 of 4

  25. MacroExpress– Example #4 of 4 Example – Process Swets invoice, GST <REM2:Once on the invoice screen, hit CTRL-G><TEXTTYPE:<TAB><TAB><TAB><TAB>><DELAY:.5> <REM2:tabs you down to the Locations section><TEXTTYPE:<ARROW DOWN> <ARROW DOWN><ARROW DOWN><ARROW DOWN>><DELAY:.5> <REM2:in Locations, choose the third selection WLU Library Periodicals> <TEXTTYPE:<TAB><TAB><TAB><TAB>><DELAY:.5> <REM2:tab user to Other Charges under Amounts><MMC> <REM2:moves the mouse to where the cursor is><DELAY:.5><MMP2:10,0> <REM2:moves the mouse over 10px, since no key combo can do this on this screen><DELAY:1><LCLK> <REM2:clicks on the elipses><DELAY:1><TEXTTYPE:<ALT>E> <REM2:Click Edit.. to edit invoice fees><DELAY:1><TEXTTYPE:H> <REM2:On the Add/edit Adjustment dialogue box, choose H for HANDLING CHARGE in the Charge Type> <DELAY:1><TEXTTYPE:<TAB><TAB><TAB>><TEXTTYPE:<TAB><TAB>><DELAY:1> <REM2:tab down 2x to the Commit to Fund field><TEXTTYPE:post-s><DELAY:1><TEXTTYPE:<ENTER>> <DELAY:1><TEXTTYPE:<ALT>O><DELAY:1><REM2:Click OK><TEXTTYPE:<ALT>O><DELAY:1> <REM2:Click OK><TEXTTYPE:<ALT>N><DELAY:1><REM2:Get to Notes tab><TEXTTYPE:<TAB>> <DELAY:1><REM2:tab down to notes field><TEXTTYPE:100% GST exempt> <REM2:Type this text in the notes field> <TEXTTYPE:<ENTER>><TEXTTYPE:Actual invoice total $>

  26. MacroExpress– Example #4 of 4 Example – Process Swets invoice, GST

  27. Is MacroExpress necessary? • it takes time to become accustomed to using macros • there is an initial time commitment that can seem to • to outweigh the benefits • how much time do you spend in front of a computer? • determine the amount/level of repetitive tasks • determine the complexity of software used • determine the software’s built-in (macro) tools Customer list

  28. MacroExpress Resources

  29. MacroExpress Resources

  30. MacroExpress Resources

  31. MacroExpress Resources

  32. MacroExpress Resources

  33. MacroExpress Resources

  34. MacroExpress Resources • Beginner • Setting up and using Macro Express • Using wizards to create macros • Running and Activating macros • Intermediate • Using variables to enhance your macros • Handling Windows and other programs • Using command line arguments • Advanced • Working with the Windows Registry commands • Processing data within files • Handling applications using Window Controls

  35. Questions or comments? Greg Sennema Electronic Services Librarian Wilfrid Laurier University Session 1912

More Related