>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #10 >Newsletter #12

VBA TUTOR NEWSLETTER #11 ~ 1-7-2000 Help for the beginner to intermediate VBA programmer Subscribers 360 ~ ^75 in June

You might have noticed the change in web design for 'www.vbatutor.com' over the last month, especially the improved navigation. It has been based upon the web design concepts found in Designing Web Usability - The Practice of Simplicty by Jakob Nielsen.

~ VBA in GENERAL ~

[ 1 ] The tutorial for this month is based upon a code example sent in by a subscriber that deletes all VBA code from a EXCEL Workbook. The tutorial goes on to look at how to implement a "run once" AutoOpen macro in WORD. [ SKILL LEVEL: ALL ] [ 2 ] One problem that you can run into when developing a VBA project is memory loss. [No not YOU, the COMPUTER! ] An excellent little program I have been using recently is 'Memory Cleaner' [39kb]. It is a MUST HAVE utility to reclaim those memory pages lost when your VBA project crashes during debugging.

~ COOL VBA RESOURCES ~ Download some VBA Power Tools for both users and developers from 'www.office.vba'. While you are there, have a look at the large selection of Premium Downloads of articles on using VBA in Word. [ SKILL LEVEL: ALL ] If you wish to look at some more advanced VBA in OFFICE, have a look at the 'Microsoft Office 97 Developer' FREE courseware @ www.freeskills.com. [ SKILL LEVEL: Intermediate to Advanced ]

~ VBA in WORD ~

Got to the Print Preview and found a mistake? Just click on the Magnifying Glass button to deselect and it will change to an 'I bar' cursor. You can then edit your document as normal.

~ COOL WORD RESOURCES ~ Pay another visit to Scott Matthewman's VBA Tips for a NEW tip on how to replace the standard 'Insert Table' menu item with an improved one that gives you the choice of adding either above or below the current selection. [ SKILL LEVEL: Beginner to Intermediate] If you wish to look at some more advanced VBA in word, have a look at the 'MS Word 97 Visual Basic for Applications' FREE courseware @ www.freeskills.com. [ SKILL LEVEL: Intermediate to Advanced]

~ VBA in EXCEL ~

The next time you want to undo or redo, use Excel's 'Undo' and 'Redo' buttons that include a drop down running list of previous actions.

~ COOL EXCEL RESOURCES ~ Download some VBA Power Tools for both users and developers from 'www.office.vba', such as the very handy 'Excel 97 Code Cleaner'. Also have a look at the selection of Premium Downloads of articles on using VBA in Excel. [ SKILL LEVEL: ALL ] If you wish to look at some more advanced VBA in Excel, have a look at the 'MS Excel 97 Visual Basic for Applications' FREE courseware @ www.freeskills.com. [ SKILL LEVEL: Intermediate to Advanced ]

~ VBA in ACCESS ~

If you have had trouble using email hyperlinks in ACCESS, the most likely cause is failing to prefix the email address with "mailto:". eg. "mailto:garyradley@standard.net.au". This results in the error "Unable to open http://garyradley@standard.net.au".

~ COOL ACCESS RESOURCES ~ If you wish to look at some more advanced VBA in Access, have a look at the 'MS Access 97 Visual Basic for Applications' FREE courseware @ www.freeskills.com. Also check out the large selection of articles on using Access in Office at the www.officevba.com. [ SKILL LEVEL: All ]

VBA TIP REQUEST FORM Contact Name: Tip Request: Unsubscribe from this newsletter!

© 2000 Gary Radley