Thread: VBA Help file
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 39
Default VBA Help file

For Each xlAddIn in xlApp.AddIns
If xlAddIn.Installed then
xlApp.WorkBooks.Open(xlAddIn.FullName)
End If
Next


This works fine for add-ins. I don't have AutoOpen routines in
personal.xls, and for this purpose it's not critical that all
functions are available (which as you said, all are not).

Although NickHK found the help file I'm looking for, I'm keeping a
shortcut to this VBS script because it's handy to be able to open the
VBE window and the Help screens all at once if I want to experiment.

The shortcut to Help is faster when that's all I want. Plenty of room
for two shortcuts.