Gary Radley

SITE #2: ~ https://secure.elementkjournals.com/cbt/

At this Element K Journal "QuickSkill CBT" site, you can select from a large range of Interactive Tutorials on CD.

**********

WORD TIP:

The following code demonstrates how to use the "StoryRanges" collection to find hyperlinks in a document area that contains a range of text, and to then delete the Hyperlink code 'behind the text', but not the actual text on the page.

Sub DeleteHyperlinks()
Dim hplnxs As Range
For Each hplnxs In ActiveDocument.StoryRanges
Do While hplnxs.Hyperlinks.Count > 0
hplnxs.Hyperlinks(1).Delete
Loop
Next hplnxs
End Sub

To find out more about the "StoryRanges" collection, do a search of the online help in the VBA Editor. Try and examine and analyse (& try maybe) some of the examples given.

EXCEL TIP:

Sometimes we forget some basic windows skills such as drag and drop. So, the next time you are reorganizing your Excel projects that involves shifting worksheets from one workbook into another, just set the workbooks into windows, reduce their sizes so you can see both worksheet tabs at the bottom, and then just drag and drop the Worksheets to their new locations. Simple!

ACCESS TIP:

To export an ACCESS table into another ACCESS project, Right click on the table in the Database Window, then select "Export" from the drop down menu. Use the browse button to navigate to the Access project you wish to export to, then select the "Save" button.

POWERPOINT TIP:

At this site,http://www.mvps.org/skp/vba.htm , you will find an excellent range of Powerpoint VBA Tips, Explanations and Examples.

**********

If you wish to unsubscribe, send an email with "unsubscribe" as the subject to unsubscribe@austarnet.com.au

**********