Open Specific Folder

[robbydogg]

Hello,

Hopefully this is a really simple request - All i need is a bit of code to runt aht opens a specific folder on the network, after running off a few items first.

I have put in the code to run the queries / macros i need but after this i want it to open the folder and display the contents it has just created.

Any ides?

Thanks muchly

 

[DCrake]

Do a search on Common dialog controls

 

[robbydogg]

hi,

after a bit of searching on this site, i found exatcly what i needed.


Private Sub Command8_GotFocus()
Dim stAppName As String
stAppName = """C:\WINDOWS\explorer.exe"" /e, \\SVR034\Public\ Data\Data Extracts"
Call Shell(stAppName, 1)
End Sub


thanks
rob