Thanks Tom and Chip for your suggestions. Tom I have kept yours for other
uses.



The reason that I want the macro to only open the directory and no more is
either because I have a lot of backups of a file that I am creating and want
to easily go back to earlier files or because there are several files that I
know are in a directory and I can easily choose then which one I want.


Many thanks,

Roger

"Chip Pearson" wrote in message
...
Roger,

What does "open a directory" mean? Do you want to allow a user to select a
directory from a dialog box? If so, see
http://www.cpearson.com/excel/BrowseFolder.htm . If not, you need to be
much more specific in your post.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Roger B." wrote in message
...
I need a macro that will open up a directory, not a file. The directory's
full address is on a sheet in the same file where the button is. I am
using mainly Excel 5 files although occasionally I use the Excel 2002
version if it absolutely necessary.

Any help would be greatly appreciated,

Roger