View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
M. Authement M. Authement is offline
external usenet poster
 
Posts: 94
Default Stop showing the Folder explorer bar?

Nick,

I assume that bit of code would hide Excel's Web toolbar, but it does do
what I am looking for (at least I could not get it to work). What I am
attempting to do is open a folder in a separate Windows Explorer window that
contains a bunch of files (Word documents to be exact). Using the
ActiveWorkbook.FollowHyperlink does achieve this goal, but on the left side
of the window is a treeview list of folders. If I select ViewExplorer Bars
I can see that the Folders bar is checked (and can then uncheck it so that
it no longer appears). Can I does this programmatically using VBA code, and
more specifically, how?

"NickHK" wrote in message
...
Application.CommandBars("Web").Visible = False

NickHK

"M. Authement"
.gbl...
I have added a custom menu as part of an add-in which contains a button
that brings up a folder. This works, but the Folder explorer bar is shown
and I would prefer that it didn't. Any thoughts on how to eliminate the
Folder view? The code I have attached to the button is shown below.

ActiveWorkbook.FollowHyperlink
Address:="\\someservername\folder1\folder2", NewWindow:=True

Oh, and I am using Excel 2003/WinXP. TIA for your help.