Thread: Opening a folder with VB
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Opening a folder with VB
What do you mean "open" a folder? Open the folder window to display
files and folders within that folder?

Try

Dim FolderName As String
FolderName = "C:\Test"
Shell "explorer " & FolderName

or you can use

ThisWorkbook.FollowHyperlink "file://C:\Test"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Sun, 15 Mar 2009 00:20:00 -0700, Brettjg
wrote:

Can I open a folder with VB code, without using a hyperlink? Regards, Brett
Reply With QuoteReply With Quote