View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Did anyone know about "Shell" function?

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?