Open a Folder
 

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

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

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

Open a Folder
 

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

Open a Folder
 

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

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

Open a Folder
 

As long as you don't want your code to interact with Windows Explorer, you
should be able to open it using this...

Shell "explorer.exe", vbNormalFocus

--
Rick (MVP - Excel)


"danpt" wrote in message
...
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

Open a Folder
 

Thank you very much, Rick
Shell "explorer.exe J:\Backup\bBackup", vbNormalFocus
which is what I wanted.

"Rick Rothstein" wrote:

As long as you don't want your code to interact with Windows Explorer, you
should be able to open it using this...

Shell "explorer.exe", vbNormalFocus

--
Rick (MVP - Excel)


"danpt" wrote in message
...
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

Open a Folder
 

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

Open a Folder
 

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

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

Open a Folder
 

Hello
What if you wanted to make J:\Backup\Backup a user defined location, say it
is defined by a value in a cell of a spreadsheet:
Exa - cell B3 = "J:\Backup\Backup "

I tried
mypath=cell(3,2)
Shell "explorer.exe mypath", vbNormalFocus

it says mypath is not a directory

thanks a bunch



"danpt" wrote:

Thank you very much, Rick
Shell "explorer.exe J:\Backup\bBackup", vbNormalFocus
which is what I wanted.

"Rick Rothstein" wrote:

As long as you don't want your code to interact with Windows Explorer, you
should be able to open it using this...

Shell "explorer.exe", vbNormalFocus

--
Rick (MVP - Excel)


"danpt" wrote in message
...
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