Open a folder in excel [Closed]

Report
-
 Blocked Profile -
Hello,

What is the vba code to open a folder in excel, i have tried assigning a hyperlink to a command button, but this opens the folder from the root and not from the sub directory. e.g. C:\Home\Folder... (Just to clarify, i need to open a folder and not a file)

Does anyone know how i can get around this??

thanks

PM

3 replies

Hi,

This doesnt contain the information i need, do you know of anything else that will work.

thanks

PM

Hi PM,

Are you looking for more suggestions actually?

Thanks in advance.

Dear PM,

Please consider checking the solved problem through the following link:

https://ccm.net/forum/affich-118204-open-an-excel-file-from-aform-in-vba

and hope that it helps you in your difficulty.

Thank you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!