View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Need a "GetFolder method"

Helge,

Download Jim Rech's BrowseForFolder example at
http://www.bmsltd.co.uk/DLCount/DLCo...eForFolder.zip .


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


"Helge V. Larsen" wrote in message
...
I have used the "GetSaveAsFilename method" to let the user give

a file name.
But now I need a "GetFolder method" that will let the user give

a folder
name. The "GetFolder method" does not exist in VBA. Has anyone

programmed
something that can do the trick ? - or can you give me a hint

on how to do
it ?