Thread: Open a Folder
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Open a Folder

If you just want to review the contents of a folder, you could use
application.getopenfilename or application.getsaveasfilename



danpt wrote:

Hi, Steve
I just want to open an Explorer type window to reveal the contents of the
bBackup folder.

"Steve Yandl" wrote:

Define what you mean by "open the bBackup folder". Are you wanting the
SaveAs dialog to appear opened to the bBackup folder or are you just wanting
an Explorer type window opening to reveal the contents of the bBackup folder
or something else?

Steve Yandl


"danpt" wrote in message
...
I backup different xls file groups in J:\Backup\aBackup, J:\Backup\bBackup
and so on.
Please help me to scripte a vba that will open the bBackup folder.
Thanks





--

Dave Peterson