Thread: Open a Folder
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
danpt danpt is offline
external usenet poster
 
Posts: 49
Default Open a Folder

Hi, Marvin
It is not quite working.
WScript needs to be defined.
I don't know how. Please take a look again.
Thanks


"Marvin P. Winterbottom" wrote:

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