Re: Excel VBA Help Gripe

Doug,

If you can get a copy of the Excel 97 help file "Vbaxl8.hlp",
it should work in all later Excel versions. I use it in xl2002.
I agree, it is far superior to the web type interface that MS went to.
It also helps ensure that code used will work in all xl versions.
I call it this way in WindowsXP (with thanks to Chip Pearson)...

Sub ShowVisualBasicHelp()
'The help file for Excel VBA
Shell "c:\Windows\Winhlp32.exe Vbaxl8.hlp", vbNormalFocus
End Sub

Regards,
Jim Cone
San Francisco, USA


"Doug Glancy" <nobodyhere@xxxxxxxxxxxxxxxx> wrote in message news:uMUHs5QnFHA.2916@xxxxxxxxxxxxxxxxxxxxxxx
Keith,

I usually get better results by typing the word, e.g, "range," clicking on
it, and pressing F1. I don't know why the results are different than the,
often irrelevant, results from doing a search in help, but they are. Maybe
the first is accessing the web and the second isn't?
As an aside, I miss the old "Contents, Index, Find" Help search dialog.
Maybe there's a way to get it back in XL 03 but I haven't stumbled across it
yet.
hth,
Doug


"keithb" <k31thb@xxxxxxxxx> wrote in message
news:eHYKXzQnFHA.3900@xxxxxxxxxxxxxxxxxxxxxxx
> Am I the only one having difficulty using Excel VBA help? It would be ever
> so much more useful if documentation for objects, properties, events and
> methods were returned in the search listings. As a new user, I did not
know
> whether a Range is an Object, Property, or Collection, so I searched for
> "Range" which did not return anything useful. As a result I wasted a long
> time before finding Range under Collections.
> Keith

.