Good Afternoon:
Here is the weekly update regarding Microsoft Product Line and Bug
Reporting.
Have a great holiday weekend.
Christopher McMillan
VA CT Healthcare System
Computer Training Specialist
Telephone Number: 1 800 645 6373 extension 3027
FTS Number: 700 428 3027
Fax Number: 1 203 937 3459
Pager Number: 1 800 201 5625 pager 0378 (Dial your number after beep)
E-mail: [log in to unmask] or [log in to unmask]
-----Original Message-----
From: [log in to unmask]
[mailto:[log in to unmask]] On Behalf Of Woody's Office
Watch
Sent: Friday, May 28, 1999 11:42 AM
To: [log in to unmask]
Subject: Woody's Office Watch #4.21
--==>> WOW-WOODY's OFFICE WATCH <<==--
(your own Microsoft Word & Office guru every week!)
26 May 1999 Vol 4 No 21
A word from this weeks sponsor ...
>>>>>>>>>>>>>>>>>>>> LOST YOUR PASSWORD? <<<<<<<<<<<<<<<<<<<< Password
recovery tools for Excel, Word, Outlook, Access, Windows NT, Exchange,
Lotus, Schedule, Mail, Backup and more!
Easy to use, powerful and *affordable*.
>> Get your FREE demo NOW from http://www.LostPassword.com <<
IN THIS ISSUE: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Where can you get the best
price for Office 2000? We're starting a search across the web to find you
the best deal.
There's yet another addition to the Microsoft Office family
* Vizact. The Thanksgiving woes in Outlook continue, more on 'flakey' Net
Folders and a rant on the Outlook address book.
Automatic numbering in Word. How to import contacts info from Outlook into
Access and Claude Almer starts the VBA Challenge.
We announce some winners in our great book giveaway - all they did was
subscribe to WOW and they've won a computer book!
JOIN WOW, hear the latest Office news FREE and FIRST send
blank email mailto:[log in to unmask] or
http://www.woodyswatch.com/wow/ . And don't forget our free
Windows newsletter http://www.woodyswatch.com/www/ or
mailto:[log in to unmask]
* WHO'S GOT THE BEST PRICE FOR OFFICE 2000?
* WHAT IS VIZACT ?
* THE WORD OF LAW
* WOW READERS ARE WINNERS EVERY WEEK
* AUTOMATIC NUMBERING IN WORD
* MAXIMIZING OUTLOOK 2000
* FOLLOW-UP ON THANKSGIVING
* FOLLOW-UP ON MULTIPLE OUTLOOK WINDOWS
* FOLLOW-UP ON NET FOLDERS
* ADDRESS BOOK DIATRIBE
* OUTLOOK TO ACCESS
* BETA TEST INVITATION
* THE VBA CHALLENGE
* VBA ANSWERS AND CORRECTIONS
* VBA CLASSES
* VBA RESOURCES DELIVERED BY VALET READERS
* ENTERTAINMENT NICHE
* BACK ISSUES?
* WOODY's CONTACTS in North America or Australia
* ADMINISTRIVIA, subscribing, unsubscribing etc
WHO'S GOT THE BEST PRICE FOR OFFICE 2000? ~~~~~~~~~~~~~ With the launch of
Office 2000 only a few weeks away, we'd like to try something that should
benefit many WOW readers thinking of buying Office 2000.
There are many retailers that are offering Office 2000 - it's the same
product so it's a question of who is offering the best price.
The official US retail prices for Office 2000 are:
Standard Edition $499
Standard Edition Upgrade $249 ($40 upgrade rebate)
Small Business Edition $499
Small Business Edition Upgrade $249 ($40 upgrade rebate)
Professional Edition $599
Professional Edition Upgrade $349 ($40 upgrade rebate)
Premium Edition $799
Premium Edition Upgrade $449 ($50 upgrade rebate)
Premium Edition Upgrade with Intellimouse $469 ($50 upgrade rebate)
Developer Edition $999
Developer Edition Upgrade $649 ($40 upgrade rebate)
You can work out what products are included in each package
from this chart
http://www.microsoft.com/insider/offers/o2k.htm#A6
UPGRADE PRICES
The upgrade package is for anyone with an earlier version of Microsoft
Office or other Microsoft desktop applications. The same boxed package can
be used by owners of suites of desktop applications other than Microsoft's.
The difference is that owners of qualifying Microsoft products can send in
for the upgrade rebate - effectively reducing the total cost by either $40 o
r $50 for existing customers.
Curiously, Office 2000 Developer only gets a $40 rebate even though it
includes the Premium edition which gets a higher rebate.
Be careful when comparing prices for Office 2000 between retailers, some
include the mail-in rebate in their quoted price (even though you pay a
higher price and get your money later) and others don't.
OFFICE 2000 PRICE SEARCH
There's no need to pay those official retail prices,
competition is hot and many retailers are offering
discounts. We'd like to find the cheapest so that all WOW readers can
benefit. For example the Netscape store
http://store.netscape.com/office2000/index.html is offering discounts
between $30 and $110 depending on the product.
The Microsoft online store http://shop.microsoft.com/ uses various retailers
who may also offer discounts, but you have to plough through much of the
online ordering process including compulsory registration just to see what's
on offer. The policy of requiring your name and other details before
finding out the real prices is presumptuous and needs a re-think.
If you find good North American prices, let us know at
[log in to unmask] . Please include the name of the company, web
link and price summary (excluding Microsoft rebate, we want to know what you
pay up front).
We're also interested in hearing about good Office 2000 prices in other
countries around the world. What's on offer in the UK and Australia for
example?
We'll compile the best deals for the final WOW Office 2000 Special issue
coming your way on June 4th.
---->> ADVERTISE HERE FOR LESS THAN $200 <<-----
We have a special package offer on WOW advertisements
Send your message to over 100,000 Office / Windows users worldwide.
LIMITED OFFER - closes on 2nd June 1999.
>> http://www.mcc.com.au/wow/ad.htm or mailto:[log in to unmask] <<
WHAT IS VIZACT ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Now available from
the Microsoft web site is a preview of the upcoming member of the Office
family - Vizact.
Can't say that the name grabs me, but it's tool to easily add active
elements to web pages. In practice this means more attention grabbing web
pages with features like visual timeline, interactive bullets, grow shrink,
spin, color cycle, motion, transitions and other effects. Many of these can
be done now by web gurus, Vizact aims to put those choices to the hands of
us mere mortals.
All the usual Office features have been included: Outlook style bar,
templates, web folders, wizards, formatting toolbar etc.
You can find out more at http://www.microsoft.com/vizact/ including a
preview download. Note that the preview version is NOT compatible with the
Windows 2000 beta 3 (a real pity that) and you'll need Internet Explorer 5.
We haven't tried Vizact yet and will report on it in future WOW's. The
major question is how compatible Vizact effects are with earlier versions of
Internet Explorer let alone Netscape. We'll see.
THE WORD OF LAW ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Thanks to all those
WOWsers who took the time to write to our new columnist, Bob Blacksberg,
with ideas for future columns, comments, praise and general words of
welcome. Bob's now fully enthused with ideas and energy for his 'Word of
Law' column which you'll find later in this issue.
WOW READERS ARE WINNERS EVERY WEEK ~~~~~~~~~~~~~~~~~~~~~~~~ Finally we've
had some responses from winners of our book prizes! Books from MacMillan
publishers are on their way to Louis V from Montreal, Glenn J from Utah and
Randall M from Indiana. Congratulations to all - your books are on their
way to you.
There'll be a winner drawn from the subscriber list of WOW
for each issue. That lucky person will WIN a free computer
book from Macmillan's http://www.mcp.com/
Our WOW editor, Peter Deegan, will choose a winner at random from the list
of people who get each issue, he'll then contact the winner direct for
shipping information. If the winner replies within 72 hours they get their
prize, otherwise we'll redraw to find a new winner. Winners will be
announced in WOW, but email and postal addresses are not published.
DOUBLE YOUR CHANCES
We'll also be giving a Macmillan book prize away with each issue of Woody's
Windows Watch - WWW. So double your chances of winning by making sure you
join our sister publication in which Woody and Peter are joined by Barry
Simon, Peter McDonell and Sanford Weinberg to give you tips and information
on Windows.
Most WOW readers get both ezines-they're free, of
course. You can join WWW at the same address you get WOW
just by clicking this link
[log in to unmask]" target="_blank">http:[log in to unmask]
These weekly prize draws are just another way to thank you for your help and
support for Woody's Office Watch. Over the last few years, WOW has become a
significant voice to and on behalf of Office users around the world. Not
only do we give you the latest news and information (whether Microsoft likes
it or not) but tips from a range of experts.
---->> WOPR-SUPERCHARGE WORD-WOPR <<-----
Woody's Office POWER Pack is THE way to make Word better
Better Enveloping, document management, toolbars, duplex and other fancy
printing - plus lots more!
Available for Word 2, 6, 95 and 97 (for Windows)
>> FREE TRIAL: http://www.wopr.com/ <<
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THE WORD OF LAW
Advice and news on using Word in legal offices and other large organizations
from Bob Blacksberg.
AUTOMATIC NUMBERING IN WORD ~~~~~~~~~~~~~~~~~~~~~~~~~ Last issue's column
stated "The Seven Laws of Styles" and ended without explaining Law 7: Tie
automatic numbering to heading styles.
This may be the hottest issue for Word 97 in legal
practice. First, we will not finish this topic in this
column. In fact, before we can really master automatic numbering, we will
touch Word 97 at many levels. Topics to be covered will include (not
necessarily in order) the linkage of styles to templates, the relationship
of direct paragraph formatting to style based formatting, the mysterious and
intricate List Gallery (the Word VBA name for the dialog entitled "Bullets
and Numbering"), the relationship of the Windows Registry to the List
Gallery, the Outline View, the Document Map, Tables of Contents and
strategies for the structure of legal documents. We must understand the
basic conflicts in the methods Word 97 uses to format numbers and paragraph
styles. We cannot avoid some attention to the numbering tools from earlier
versions of Word.
Even to write that list feels frightening. Before we start trying to sort
these issues out, is it worth it? If there are problems with automatic
paragraph numbering and styles, why bother? Wouldn't it be easier to just
type the numbers? Isn't there an easy solution?
In the WOW spirit, if the reward is great enough, we will pick apart and
rework Word 97 to make it work, if we have to. We have to.
Attorneys love to number paragraphs in their documents. From simple
sequential numbered or lettered paragraphs, numbering in legal documents may
flower into complex schemes. Beyond outlines such as:
I. Main Heading
A. Subheading
1. Subsubheading.
legal documents may use schemes such as:
1. Main Heading
1.1 Subheading
1.1.1 Subsubheading
or
ARTICLE I Main Heading Section 1.01 Subheading.
As the preceding paragraphs indicate, the formatting of the levels is as
important to the geography of a document as the numbers. That link cries for
the use of styles. Styles force paragraphs with the same function in a
document to have the same formatting. That's what Law 2, Format Follows
Function, means.
If we want (legal) documents to be fully interchangeable and reusable, style
based formatting (supported by appropriately formatted templates) is a must.
In significant ways, Word 97 rewards documents that attach their hierarchy
of numbered paragraphs to Heading Styles 1 through 9. The built-in settings
for the Document Map and the Outline View make documents structured this way
modular and powerful to navigate and edit. The Document Map allows a user to
travel from heading to heading in a framed view. The Outline View allows
users to move, insert and delete segments of a document with a single
mouseclick or keystroke. Tables of contents can be constructed from the
contents of the headings without additional coding. When all this works,
those who write with their word processor achieve the full potential of Word
97.
The simple truth is that it doesn't always work, and the failures can be
subtle and difficult to understand.
For this column, we will describe the clash between style based formatting
and number formatting. We will save other issues for future columns.
Following the Laws of Styles, if the numbering scheme is to be attached to
Heading Styles 1 through 9, it would be natural to expect to use the format
settings for each of the styles to control all elements of the formatting of
those paragraphs, including fonts, left, right and first line indents,
paragraph spacing, borders and shading, to name some. We might even want to
use the techniques described in Law 5, "Change locally, then propagate
globally."
Troubles arise when one tries to change the numbering format. When the
numbering format is changed through the List Gallery, left indents, first
line indents and tab settings for Heading Styles 1 through 9 that have been
set in those styles (other than through the List Gallery controls) can
change. Users perceive these changes as instabilities or bugs in the
operation of the styles. In fact, Word also controls the left indent, first
line indent and first tab setting through the List Gallery. If control of
these settings is made solely through the settings in the List Gallery, the
problems can be limited. Using the List Gallery for these settings is harder
and far less natural than the methods of Law 5.
We will need to dig deeper to fully understand and control these functions.
A solution lies in developing and storing templates with the numbering and
associated formatting properly configured for the heading style levels, then
applying those style settings to a document through the Style Gallery (or
the equivalent macro function), when it is necessary to change numbering
formats. The number levels themselves are applied through application of the
appropriate style. If set up and managed properly, end users can apply
automatic numbering consistently and accurately.
We (just) need to work through the techniques and traps for those templates.
There are plenty of twists and turns.
Corrections and Clarifications:
The following macro for removing the "Automatically Update" property of a
documents styles avoids an error relating to character styles:
Public Sub RemoveAutomaticallyUpdate()
Dim aSty As Style
For Each aSty In ActiveDocument.Styles
If aSty.Type = wdStyleTypeParagraph Then
aSty.AutomaticallyUpdate = False
End If
Next aSty
End Sub
Returning to the bookshelf, please consider Word 97 for Law Firms,
http://www.amazon.com/exec/obidos/ASIN/0761513167/, an essential guide and
reference for Word 97.
In the very brief time since the distribution of the first Word of Law, many
of you have written thoughtful and complimentary messages. Thanks for the
suggestions and encouragement. It will take hard work to live up to the
expectations, but it is worth the try.
Comments or questions mailto:[log in to unmask]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THE OUTLOOK ORIGINAL
Help on organizing Outlook from Barry Simon, Woody's co-author on 'The
Mother of all Windows' books and Woody's WINDOWS Watch.
MAXIMIZING OUTLOOK 2000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I've signed
contracts with Osborne McGraw Hill to do a book entitled Maximizing Outlook
2000 due out in the northern fall of this year. Expect almost 600 pages
that tell you (almost) everything about Outlook. I'm even planning to say
something about Outlook as an Exchange Server client, an issue that I don't
discuss in this column.
FOLLOW-UP ON THANKSGIVING ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I reported on
problems with the date of Thanksgiving this year. That's apparently a
problem left over from Outlook 97. If you've successively upgraded from
that version, you may have the date wrong for this year. Both Outlook 98
and Outlook 2000 have it right. I reported to several readers that I had
the date wrong on a fresh Outlook 2000 installation but I recently realized
that I had imported a calendar from another machine - one that went back to
Outlook 97.
FOLLOW-UP ON MULTIPLE OUTLOOK WINDOWS ~~~~~~~~~~~~~~~~~~~~~ I was sent an
alternate to Icon Corral for putting icons in the notification area -
Trayer, available at http://home1.pacific.net.sg/~ngkf/trayer/default.htm.
I haven't had a chance to check it out but figured it was worth mentioning.
FOLLOW-UP ON NET FOLDERS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Last week's piece
on Net Folders generated a flood of mail including about a dozen messages
reporting problems like the one that I mentioned or worse - howls of anguish
from folks that had tried to get Net Folders to work and had failed, often
after hours on the phone with MS Tech Support. Here is a telling quote from
one message: "I finally got a few messages from the Microsoft MVP people,
acknowledging that the Net Folders feature is "very flaky", and that it was
even more flaky in OL2000 than OL98." The word flaky appeared in a lot of
these messages.
I remind you that except for a brief problem that
eventually healed itself (with a little bit of help from
MS), Net Folders have worked fine for me. But I draw two morals from my
mail. First, while you should try it, be prepared to drop it if you can't
get to work. And second, that Microsoft needs to work on fixing this
feature.
A few more remarks. A number of readers commented that they could not find
a Share command on their File menu. I remind you that Net Folders requires
Outlook 98 or 2000 (not 97) and that, with OL 98, you may need to explicitly
install Net Folders by rerunning setup.
One reader pointed out that for Net Folders to work, your mail system has to
support Rules (he was using HP Open Mail whose Rule support is incomplete
and Net Folders seem not to work). One reader had problems with incoming
messages not always being processed and discovered that adding an explicit
rule to read incoming Net Folders messages helped.
ADDRESS BOOK DIATRIBE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I hate to pile on
the Outlook Team several places in one week but I've got a big
disappointment to discuss that isn't fixed in Outlook 2000. Indeed it is
one of my top three disappointments in OL 2000 (the other two are the fact
that you can't set up the system to always use Word Mail to read incoming
messages and the continuing lack of Caller ID support) and that involves the
address book.
I regard the Outlook Contact form as one of the high points of Outlook's
design - a compact powerhouse of intelligent presentation of lots of data.
The phone list view of the Contacts folder especially with the ability to
customize it with the fields chooser is a great way to present contacts in
table view.
There are times when Outlook or Office needs to present you with an Address
Book. This happens if you hit the Address Book icon, hit the To: button on
outgoing mail. It also happens in Word if you do Insert Address. Given the
Contacts table list, one would have hoped that this would be the address
book that Outlook gave you but it isn't.
There are times when you ask for contact info - for example, if you click on
a contact in the address book or click on an email address in an outgoing or
sent message. Given the wonderful contact form, you'd expect Outlook to use
it but it often doesn't.
Exactly what happens depends on whether you are in C/W Corporate/Workgroup)
mode or IO (Internet Only) mode. In CW mode, Outlook uses the brain dead
MAPI address book. This doesn't let you sort on any column but name. By
default it lists and sorts on First Name first although this can be changed
(if you know to go to Tools/Services and look at the Properties of Outlook
Address Book!). From here if you click on an entry you sometimes get a
terrible dialog with a little bit of info but sometimes you get the
wonderful Outlook Contact form. In particular, if you click on an email
address you get the Outlook contact form.
In IO mode, Outlook borrows liberally from Outlook Express
* it uses OE's Address Book (which is populated with your contacts), which
isn't half bad, although you can't see company names and mail addresses in
list view. And it always uses the OE contact properties - even when you
click on an email address. This contact form isn't awful but it's not up to
the high standard of intelligent design set
by Outlook.
No doubt, there are historical reasons that we are stuck with these strange
address book but its disappointing with a the intelligent design of
Outlook's contacts folder that it is suppressed (sometimes by OE!) in some
places where it would be natural.
Comments or questions mailto:[log in to unmask]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THE ACCESS ARCHON
Passing judgement and wisdom on the Access database system.
Comments or questions?
OUTLOOK TO ACCESS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ One of the most common
requests of people who use both Outlook and Access is to get their Outlook
contact data into Access, where they can use it in various ways. For a
while during the later phases of Outlook 97, there was an Outlook/Exchange
Wizard which would let you link to Outlook data from Access, but it was
cranky, memory-intensive, and had some fatal flaws, like not connecting to
any custom fields or even many of the most important phone and address
fields in a Contact item.
That Wizard is no longer available, so at present you are limited to several
rather unsatisfactory ways of connecting to Outlook data from Access. In
the Access interface, there is no Outlook selection in the Import dialog
(unless you count importing a text file previously exported from Outlook).
In the Outlook interface, there is a Microsoft Access selection in the
Export dialog. If you select it, and export contacts from a folder, you
will get a table called Contacts in the designated Access database, which
contains only data from the standard Outlook fields - not much use for your
custom forms!
To get data from your custom fields on custom Contact items, you have to
write Automation code, to iterate through a Contacts folder and pick up data
from each built-in and custom field (using different syntax for both), using
a DAO recordset to add records to an Access table. I have done this many
times, and it is an extremely tedious process, since you have to treat
different data types in different ways. You have to wrap text fields with
quotes, but not numeric fields, and convert Outlook's bizarre convention for
an empty date field - 1/1/4501 - to an empty Access date field. To make
things more difficult, Outlook and Access data types don't exactly match,
and use different constants in code. And there is no Properties collection
for Outlook built-in fields, although there is a UserProperties collection
for custom fields - go figure! - so you have to hard-code the names of all
the built-in fields.
After struggling through several custom Outlook-to-Access applications, I
decided to automate this process in an add-in, which will soon be published
in Smart Access.
BETA TEST INVITATION ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If anyone is
interested in beta testing this add-in, send me a message saying you want to
beta test the Outlook Automation add-in at mailto:[log in to unmask] The
requirements are as follows:
* You use Outlook 97 or Outlook 98, and Access 97.
* You have created one or more custom Outlook Contact forms, using custom
fields, and created items filled with data based on the custom form(s).
* You need to transfer your Outlook contact data
(especially from the custom forms) to Access.
Please mention that you are interested in beta testing the Outlook
Automation add-in, as I am also running a beta test for the Design Schemes
add-in, mentioned in last week's column.
Seek out Helen Feddema, 'The Access Archon' direct
mailto:[log in to unmask]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---->> LEARN FROM THE BEST <<----
Feel like you're learning Office with a certified guru helping.
Make Office an easier and more effective tool for daily use
" WOODY LEONHARD TEACHES MICROSOFT OFFICE "
available from good bookstores worldwide
>> http://www.wopr.com/books/woodyteaches.htm <<
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THE VBA VALET
A look at the programming language lurking behind Office.
THE VBA CHALLENGE ~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~ Readers questions keep
flowing in at an ever increasing rate, far too many for me to be able to
answer. And, quite frankly, some of them I just can't answer because I
don't know if a certain scenario is possible.
Let's take a look at a sample question:
"I currently have an in-house application that I am working on and I would
like to integrate it with MS Binder97.
Binder (excluding filesize bloat) seems like an incredibly underestimated
application. I can programmatically add Word documents, Excel spreadsheets
and Visio diagrams to a Binder file to encompass a sales proposal for a
client. I can even send the entire file to the printer and have it number
pages across heterogeneous documents.
One problem: why did MS not incorporate a Table of Contents function into
Binder?
Is there an existing template/macro that will do this for me?
If not, can you offer pseudo-code or VBA snippets for doing this?"
I can't answer this question on the grounds that I have never used MS
Binder. Not once. Alas, there must be users out there who can provide an
answer.
If you think you know the answer, please email
[log in to unmask] with details.
If you have similar challenging questions, send'em to
[log in to unmask] instead of myself.
From time to time we'll award a prize for an outstanding answer.
VBA ANSWERS AND CORRECTIONS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Remember a while back, I've included a few lines
of recorded code to turn the border off in a table,
like this:
Selection.Borders(wdBorderTop).LineStyle = wdLineStyleNone
Selection.Borders(wdBorderLeft).LineStyle = wdLineStyleNone
Selection.Borders(wdBorderBottom).LineStyle = wdLineStyleNone
Selection.Borders(wdBorderRight).LineStyle = wdLineStyleNone
WOWser S correctly pointed out the obvious:
"You could just use the keyboard shortcut: Ctrl-Alt-U"
A lot faster and no need to write a macro.
VBA CLASSES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Last time I was
on, I mentioned that we'd have a useful working class in the next issue.
Well, you guess it, the classes class is being held over another week at
least. I still have a massive backlog of work to catch up with.
Feel free to write and suggest a type of class you would like to see. We'll
create the best suggestion from scratch. Please keep in mind it should be
useful in Word since this will be the classes target application.
VBA RESOURCES DELIVERED BY VALET READERS ~~~~~~~~~~~~~~~~~ Note that none of
them are endorsed or recommended by Woody, Peter, myself or Woody's Office
Watch generally, we are simply passing information on as it comes to hand.
The Spreadsheet Page
http://www.j-walk.com/ss/
JWalk & Associates
Questions and answers regarding Office products and VBA.
http://www.wopr.com/lounge/
Comments or questions? Summon Claude Almer, 'The VBA Valet' direct
mailto:[log in to unmask] .
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ENTERTAINMENT NICHE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ As this issue of
WOW was prepared we amused ourselves with:
Music: 'Remain in Light' - Talking Heads
BACK ISSUES? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Did you miss the
first issues of WOW? Drop by http://www.wopr.com/wow/wow.htm#SubServ where
all back issues are stored. You can also download self-extracting archives
of back issues and search the WOW issues online.
If you don't have Web access, send mailto:[log in to unmask] for instructions
on how to get back issues via email.
WOODY's CONTACTS in North America or Australia ~~~~~~~~~
WOODY products are available from authorized outlets:
North America:
Advanced Support Group,
11900 Grant Place, Des Peres, Missouri 63131
Ph:(314)965-5630 Fax:(314)966-1833
mailto:[log in to unmask]
Australia, New Zealand, Asia:
My Computer Company
1 Allen St (PO Box 114)
Glebe NSW 2037 Australia
Ph: (02) 9692-9322 mailto:[log in to unmask]
Fax: (02) 9692-9485 http://mcc.com.au/
All Woody's books and software are available from his Aussie outlet.
Sales of Woody's books and software help support the considerable costs of
writing and distributing WOW as a free bulletin each week. Help keep WOW
alive and free by buying Woody's products.
ADMINISTRIVIA, subscribing, unsubscribing etc ~~~~~~~~~~
This copy of WOW was originally sent to: [log in to unmask]
Join, Leave or change address from our Web site
http://www.woodyswatch.com/wow/
Email: Subscribe: [log in to unmask]
Unsubscribe: [log in to unmask]
Note: replying to any issue of WOW to unsubscribe or comment will NOT work
and your message will not be read by a human. Use the appropriate address
or web page above instead.
Back issues : http://www.wopr.com/wow/wowarch.shtml and
also at the Zdnet Help Channel
http://chkpt.zdnet.com/chkpt/hud0007500a/www.zdnet.com/zdhelp/filters/office
/wow/
WOW reader comments: to the appropriate columnist or
mailto:[log in to unmask]
ADVERTISING:
Reach Office and Windows users throughout the world at very
reasonable rates ... http://www.mcc.com.au/wow/ad.htm
mailto:[log in to unmask]
WOODY's WINDOWS WATCH
is our companion FREE newsletter that gives you all the
skinny on Windows. To join at the same address as you use
for WOW
[log in to unmask]" target="_blank">http:[log in to unmask]
Visit our web site http://www.woodyswatch.com/www/ or
mailto:[log in to unmask]
PRIZES:
A subscriber is chosen at random from each issue of WOW and WWW to win a
FREE copy of a computer book from Macmillan publishers http://www.mcp.com/ .
All subscribers worldwide are entered into each draw simply by subscribing
to both publications.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WOODY's OFFICE WATCH - Copyright 1999, ISSN 1328-1674 Pinecliffe
International and Peter Deegan. All rights reserved.
REDISTRIBUTION is allowed only with permission. You may circulate copies of
WOW by _manually_ forwarding it, providing (1) you forward the issue in its
entirety, (2) no fee is involved, and (3) you forward no more than three
issues to any one individual.
After that, please encourage your correspondents to send e-mail to
[log in to unmask] to get their own *free* subscription.
Everyone is welcome! Tell your friends about WOW!
=======================================================
W-O-O-D-Y-S-O-F-F-I-C-E-W-A-T-C-H
To unsubscribe forward this message to:
[log in to unmask] [[log in to unmask]]
---
You are currently subscribed to wow as: [[log in to unmask]]
VICUG-L is the Visually Impaired Computer User Group List.
To join or leave the list, send a message to
[log in to unmask] In the body of the message, simply type
"subscribe vicug-l" or "unsubscribe vicug-l" without the quotations.
VICUG-L is archived on the World Wide Web at
http://maelstrom.stjohns.edu/archives/vicug-l.html
|
