You can open the specified folder by first changing the folder path section of the script below to the path of the specific folder you want to open, and then executing the script.
Dim objShell, fn
fn = "C:\Users\user\Desktop\test\"
Set objShell = CreateObject("Shell.Application")
Set objShell = Nothing