Opening Windows Explorer...
 

Is there a piece of code I can put in a macro that would allow me to do
the following....?

After running a report which summarises the data for Names on selected
criteria, I want to make it possible for the user to select one of the
Names that appear which will then produce a specific breakdown for that
particular Name.

In addition (and this is where I need help) I would like Windows
Explorer to open up on a folder with the same Name (already set up -
unless its possible to do this automatically if one hasn't been set
up).

Any help / comments would be much appreciated

Thanks

tm


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=542077

Opening Windows Explorer...
 

Hi Timmy,

you can use something like this:

folder_you_want_as_string="C:\" 'for example
shell("explorer.exe /e," & folder_you_want_as_string, vbNormalFocus)

See help on shell function for more details.

Regards,
Ivan