Opening Windows Explorer...

[Timmy Mac1]

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

[Ivan Raiminius]

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