>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #1 >Newsletter #3

VBA TUTOR NEWSLETTER #2~ 14-1-2000
Help for the beginner to intermediate VBA programmer

This issue of the VBA Tutor Newletter looks at several simple tips to increase your productivity by improving upon the standard Menu Items in the Office suite of programs.

~ VBA in GENERAL ~

For the second tutorial, we will expand upon tutorial one by recording the 'Growfont by 1 pt' Menu Item command, then alter the recorded code to get user input on the increment to grow the font by. The new macro will then be saved as the same name as the inbuilt 'Growfont by 1 pt', therefore replacing the original Menu Item with the new macro. The tutorial demonstrates several important concepts. So, for you beginner VBA programmers, go to the following tutorial, tut2.htm.

~ VBA in WORD ~

Get frustrated when you try to delete '.doc' files. This neat Microsoft 'Word Developer' tip explains the code and procedure to add a File|Delete Current Document Menu Item. Click here.

~ COOL WORD RESOURCE ~
Using VBA to Work with Office HTML in Multiple Office Applications.

~ VBA in EXCEL ~

The following code can be used to create a macro that will save a selected/highlighted chart as either a ".gif" or ".jpg" file. It is a good demonstration of how to use "inbuilt" dialog boxes in your projects. (Why reinvent the wheel?)

Sub CreateGraphic()
fName = Application.GetSaveAsFilename("Excel Chart", fileFilter:="Gif Files (.gif), .gif,Jpg Files (.jpg), .jpg")
ActiveChart.Export FileName:=fName, FilterName:=Right(fName, 3)
End Sub

~ COOL EXCEL RESOURCE ~
An excellent Norwegian site with many clearly explained code examples.

~ VBA in ACCESS ~

Using VBA in ACCESS is not one of our strengths, although we are working on it. So, in this section, we will just point you towards some excellent resources.

~ COOL ACCESS RESOURCE ~
Publishing ACCESS Tables and Queries over the web.
[ SKILL LEVEL: Intermediate to Advanced ]

Unsubscribe from this newsletter!

© 2000 Gary Radley