Command button to open desktop folder

[crann]

Sorry to ask such a basic question.

I am simply trying to create a command button to open a folder on my desktop

Cannot seem to find this code

This is the path to the folder I want to open

C:\Users\JONATHAN\Desktop\CMS FILES

So grateful for advice

Jon

 

[pr2-eugin]

Jon, when you say open a Folder you mean simple Open the Explorer or Open Folder to select file using Code?

I am pretty sure

Application.FollowHyperlink "C:\Users\JONATHAN\Desktop\CMS FILES\"

Should be able to open it.

 

[crann]

Jon, when you say open a Folder you mean simple Open the Explorer or Open Folder to select file using Code?

Hello, Basically I want to open the folder and show the contents of that folder so the user can then select any files within that folder themselves.

Thanks

Jon

 

[crann]

Jon, when you say open a Folder you mean simple Open the Explorer or Open Folder to select file using Code?

I am pretty sure

Application.FollowHyperlink "C:\Users\JONATHAN\Desktop\CMS FILES\"

Should be able to open it.

Paul,

Thanks exactly what I wanted. So simple been searching for hours.

 

[pr2-eugin]

You're Welcome ! Good luck.