Open a folder in excelClosed

Question

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

LouisSteph · Answer

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.

PM · Answer

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

LouisSteph · Answer

Hi PM,

Are you looking for more suggestions actually?

Thanks in advance.

Open a folder in excel

3 responses

Similar discussions

Subscribe To Our Newsletter!