View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Damien Damien is offline
external usenet poster
 
Posts: 42
Default Open folder with code

I need a coding solution to the following: I have a command button on a sheet
which is to open a Windows Explorer Directory. I have previously used
hyperlinks to open and show the user with the following code (with button).

Range("V8").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("A1").Select
Application.ScreenUpdating = False

I was wondering if there is a better way to do without having the hyperlink.