Opening Windows Explorer...

  • Thread starter Thread starter Timmy Mac1
  • Start date Start date
T

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
 
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
 
Back
Top