My question is click a button and it will automatic open
that folder, but that folder is not a fix location, it
will change base on difference record. I only know how to
use Shell function to link a path and open it, did Shell
function link with a veriable? As I use a veriable to
store the current path. I read all about Shell's Help in
Excel, but I can't find any statment could help me.

Katherine,

Do you want to get at a file within a folder? If so, look at the
GetOpenFilename method, it gives a dialog box to navigate for the file.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Katherine Woo" wrote in message
...
My question is click a button and it will automatic open
that folder, but that folder is not a fix location, it
will change base on difference record. I only know how to
use Shell function to link a path and open it, did Shell
function link with a veriable? As I use a veriable to
store the current path. I read all about Shell's Help in
Excel, but I can't find any statment could help me.

Thanks for your help, I only need link & open that folder.
No need to open its files.
I know below:
Example: Shell "Explorer.exe \\Y:\sys\Temp",
vbMaximizedFocus

My question is I need to change that "\\Y:\sys\Temp" be a
veriable,say CurrentLink, I had try to change it as a
veriable, but it show no value of it. But I confirm
that "CurrentLink" already update the current path. Is
there need to add any special things to run it?

vLink = "\\Y:\sys\Temp"
Shell "Explorer.exe " & vLink, _
vbMaximizedFocus

--
Regards,
Tom Ogilvy

wrote in message
...
Thanks for your help, I only need link & open that folder.
No need to open its files.
I know below:
Example: Shell "Explorer.exe \\Y:\sys\Temp",
vbMaximizedFocus

My question is I need to change that "\\Y:\sys\Temp" be a
veriable,say CurrentLink, I had try to change it as a
veriable, but it show no value of it. But I confirm
that "CurrentLink" already update the current path. Is
there need to add any special things to run it?

Dear Tom

Yeah!!! Thank you so much for your help! I had just solve
my problem. ^_^ Thanks.

Best Regards,
Katherine
-----Original Message-----
vLink = "\\Y:\sys\Temp"
Shell "Explorer.exe " & vLink, _
vbMaximizedFocus

--
Regards,
Tom Ogilvy

wrote in message
...
Thanks for your help, I only need link & open that
folder.
No need to open its files.
I know below:
Example: Shell "Explorer.exe \\Y:\sys\Temp",
vbMaximizedFocus

My question is I need to change that "\\Y:\sys\Temp" be
a
veriable,say CurrentLink, I had try to change it as a
veriable, but it show no value of it. But I confirm
that "CurrentLink" already update the current path. Is
there need to add any special things to run it?



.