How do I only open folders and not specific files on macro using sharepoint

**tweacle** · 04-03-2020, 02:48 PM

Hi

I have the following macro that I use to open a specific file within a folder. (shown below)

Please Login or Register  to view this content.

What Im trying to do is to get it open as far as what is shown below so it open the folder but not the file but it not having it.

Please Login or Register  to view this content.

Any ideas?

Thanks

**xladept** · 04-03-2020, 02:56 PM

I think that that can't be done - if you have the folder path, which you have, you can access any file at will.

**tweacle** · 04-03-2020, 03:07 PM

Yeah thought so its just I have a folder with a different file for each month and that why I needed it . Is there any other ways?

**xladept** · 04-03-2020, 03:17 PM

None other that I can think of but if you have the filenames you're in good shape.

Re: How do I only open folders and not specific files on macro using sharepoint