Open a file folder in Windows 7 1

[deepsheep]

I have an Access 2007 application that does a search and returns a file location. I want to be able to click a link or push a button and open the location, which contains a series of PDFs.

This command works great on my computer - Windows XP

Shell "C:\WINDOWS\explorer.exe """ & FileFolderLoc & "", vbNormalFocus

But on Windows 7 seems to open My Documents, which is definatly not the location it was told to open!

I know there's got to be a solution and it's probably pretty easy, but I just can't see it... My Googling skills are weak today!

Thanks!

 

[PHV]

Why not simply this ?

Application.FollowHyperlink FileFolderLoc

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[deepsheep]

Awesome! Worked great! I knew there had to be an easyish way to do it.

Thanks!