Open a Folder
Thank you very much, Dave
I learn something new
"Dave Peterson" wrote:
Dim myPath As String
Dim SavedPath As String
SavedPath = CurDir
myPath = "J:\Backup\bBackup"
ChDrive myPath
ChDir myPath
Application.GetOpenFilename
ChDrive SavedPath
ChDir SavedPath
danpt wrote:
Hi Dave,
It opens to dialog window "Documents".
How about "J:\Backup\bBackup" instead.
"Dave Peterson" wrote:
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
--
Dave Peterson
|