Did anyone know about "Shell" function?

[Katherine Woo]

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.

 

[Bob Phillips]

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)

 

[Guest]

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?

 

[Tom Ogilvy]

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

 

[Katherine Woo]

Dear Tom

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

Best Regards,
Katherine