Thread: Open a Folder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom Marvin P. Winterbottom is offline
external usenet poster
 
Posts: 34
Default Open a Folder

Dim WshShell
Set WshShell = WScript.CreateObject("WScript.Shell")
WScript.Echo WshShell.CurrentDirectory
WshShell.CurrentDirectory = "J:\Backup\bBackup"


"danpt" wrote:

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