ABOUT BOB'S MACROS ------------------ Bob's Macros are designed to save you time in your use of Microsoft Excel and eliminate repetitious tasks. The macros will increase your productivity every time you are in Excel. The commands will save you anywhere from a few seconds to a few minutes each time you use them. Added up over the course of a year that's a lot of time savings. You do not have to be an expert to use the macros. They are designed for use by everyone. There are over 100 macros that comprise Bob's Macros. These are macros that I use personally in my job and I thought it would be useful to you. There is more to Bob's Macros than the list of macros that appear when you click on Bob's Icon. Bob's Macros adds commands to the Excel menus found at the top of the screen, and to the pop up menus when you press the right mouse button. These pop up additions you will find very useful in developing spreadsheets. The macros range from the simple to the very very powerful. All are designed for ease of use. And, by the time you read this, they will probably be a lot more than 100 macros, plus enhancements to the original set of macros. So, if you do register, I recommend that you also ask for the latest release. By clicking on Bob's Icon or by selecting "Bob's Macros" from the toolbar menu, you can see a list of almost all the commands. You can access many of the macros directly from the Excel Menus. Also, additional commands have been added to the Excel pop-up menus that are not listed on the macro list. Another nice feature is the repeat icon. If you run a macro from the macro list, this icon is automatically customized to repeat the command! And, if you highlight the icon, it reminds you what the icon is set to do. Just another way to save you time. Furthermore, you can assign any of the macros to icons or let Bob's Macros assign them to an icon for you! Please let me know what you think of the macros and any improvements that are needed. I use the macros every day and look forward to hearing your comments. And, If you think of a macro you would like to have added, let me know when you register. Sincerely, Bob Flanagan, Macro Systems INSTALLATION ------------ Installation of Bob's Macros is very easy: STEP 1 If you are using Excel 5, copy the file BOBSMACS.XL5 to your Excel startup directory. If you are using Excel 4, copy the file BOBSMACS.XL4 to your startup directory. DO NOT COPY BOTH FILES. The startup directory is almost always named "XLSTART" and is almost always a subdirectory of your Excel directory. Examples of this directory and its location are: C:\EXCEL\XLSTART OR C:\MSOFFICE\EXCEL\XLSTART By putting this in your startup directory, it is loaded each time you load Excel. This is extremely important, as Bob's Macros are designed to help you all the time while you are in Excel. And if they are not loaded when you need them, you won't get as much benefit. In case you are wondering, yes you can put the the files in a directory other than your startup directory. But, we don't recommend it as the Excel menus do not have the new commands added until the macro file has been loaded. STEP 2 Copy the file BOBSMACS.HLP to your Windows directory. This help file is quite extensive and is provided instead of a manual. STEP 3 Try them and you'll like them. Then register! HOW TO REGISTER --------------- When you register your copy of Bob's Macros, Macro Systems will send you registration instructions that will allow you full use of the macros. If you reguest the latest version ($5 shipping and handling extra), you will be sent a disk containing the latest versions for both Excel 4 and 5. In addition to using the form below to buy Bob's Macros, you can also use it to order ReportRunner. ReportRunner is a spreadsheet and macro system that prints reports automatically based on stored report setup information. Multiple reports can be printed just by highlighting the report descriptions and selecting print from ReportRunner's menu. See the section in the Bob's Macros Help for more details. If registering by mail, send the form below with your payment to: Macro Systems 1008 Lawndale Road Wilmington, DE, USA 19810 You may pay by check or cash. If you are paying from outside the U.S., you may pay only by cash, by a check drawn on a U.S. bank or by an international money order. You may also charge your order to your Compuserve account by typing GO SWREG. Use the following registration numbers depending on your order: Cost Number Use for: $19 3553 Registration only of Bob's Macros $24 3554 Registration and disk containing the latest version of Bob's Macros $19 3990 Registration only of ReportRunner $24 3991 Registration and disk containing the latest version of ReportRunner $36 3993 Registration and disk containing the latest version of ReportRunner and Bob's Macros CREDIT CARD ORDERS ONLY: ------------------------ You can also order with MC, Visa, Amex, or Discover from Public (software) Library by calling 800-2424-PsL or 713-524-6394 or by FAX to 713-524-6398 or by CIS Email to 71355,470. You can also mail credit card orders to PsL at P.O.Box 35705, Houston, TX 77235-5705. THE ABOVE NUMBERS ARE FOR CREDIT CARD ORDERS ONLY. THE OPERATORS CAN NOT PROVIDE ANY SUPPORT OR INFORMATION ON THESE PRODUCTS, NOR RELAY ANY SUCH REQUEST. Any questions about the status of the shipment of the order, refunds, registration options, product details, technical support, volume discounts, dealer pricing, site licenses, etc, must be directed to Macro Systems, CIS Email 72774,416 or the address at the top. Both PsL and CompuServe will notify us on the day of your order and we will fill it immediately. ORDER FORM FOR MACRO SYSTEMS PRODUCTS: Registration fee: Bob's Macros _______ X $22 = _______ ReportRunner _______ X $22 = _______ If ordering both, fill in the following instead of the above ReportRunner & Bob's Macros ________ X $34 = ________ Shipping and handling for disks*: Disks Needed ________ X $5 = ________ TOTAL AMOUNT: ________ Note: Purchase of disks is optional, but recommended. This insures that you have the latest release. * If you want the latest version, you need only pay for 1 disk Mailing address (please print) Name ____________________________ Address ____________________________ ____________________________ City,State/Province ______________________ Country & Postal Code _____________________ Payment Method (Please Circle) Check Cash MasterCard Visa Amex Discover If by Credit Card: Card Number _______________________ Expire Date _____________ Name as it appears on the card: ______________________________ NOTE: CREDIT CARD ORDERS MUST BE SENT DIRECT TO PsL IN TEXAS. CREDIT CARD ORDERS CAN NOT BE ACCEPTED IF SENT TO MACRO SYSTEMS IN DELAWARE. THIS IS A PsL REQUIREMENT.