Creating a Read Only Directory - VBA

**ironfelix717** · 07-22-2018, 10:14 AM

Hi,

In short:

My macro allows for editing a "database entry". On creation of a new entry, a directory is created to store files at the root of the .XLSM file. Then other sub directories are created. All files (attachments) are uploaded via a userform.

The user will have the choice to view the explorer window of the directory by a button click in the userform, but I would only like it to be read only. So they can't modify. However, my VBA code needs to be able to modify (add, delete, rename) files within the directory.

A good point: it doesnt necessarily have to be read only. I just want them to click the button, see the files in the folder, but not be able to modify.

Any tips?

Thanks for all the help, folks!!!

**Greg M** · 07-23-2018, 07:32 AM

Hi there,

If you want a User to be able to view the list of files contained in a folder (without being able to open any of those files) you could use the following code:

Please Login or Register  to view this content.

I'm assuming that the filenames you want to view are those of Excel files, but if not, just change the value of the FileFilter to suit.

I've also assumed that you want to start searching from the folder which contains the workbook which contains this code - if not, just change the starting-point to suit your own requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M