Open a folder for viewing from a UserForm

[Gabor]

Once one of you guys was kind enough providing me the code below.
This is a CommandButton on a Form that opens an image in a separate window.

Please Login or Register  to view this content.

Now, what I'd like to have is another CommandButton that instead of opening the image, it opens a Windows Explorer window with the Folder on it's screen the relevant picture is residing in.

So basically the code would take the Address of the image that is stored in Cells(MyLine, MyPic) , would chop off the filename, leave the address of the folder only and would open the Explorer with that folder shown.

Not sure if it is clear enough.

Thx
Gabor

[Leith Ross]

Hello Gabor,

Place this macro in a Standard VBA Module in your project. When you call the macro, the full folder path follows the macro.
Calling Example

Please Login or Register  to view this content.

Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Gabor]

Leith,

Thanks I have made it work.
Almost.
The cell contains a string that is the path and the filename so using your code first I have to modify that string in such a way that the filename is omitted.
Example:
The content of the cell is:
C:\Documents and Settings\gz41rs\My Documents\My Pictures\09-Fam1Motors\PC170123.JPG
So to make the code work I need to eliminate from the End of the string this: PC170123.JPG
so it will look like this:
C:\Documents and Settings\gz41rs\My Documents\My Pictures\09-Fam1Motors\

And the code will work then.

Of course the filenames are with different lengths.

Any ideas?

Thanks, Gabor

[Leith Ross]

Hello Gabor,

I updated ShowFiles so you can use the full path. The variable Fp is file directory path.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Gabor]

Works fantastic.

Thanks

Gabor

[wilro85]

Hello Gabor,

Place this macro in a Standard VBA Module in your project. When you call the macro, the full folder path follows the macro.
Calling Example

Please Login or Register  to view this content.

Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

I'm trying to use this to work with a SharePoint website, but nothing is happening. The code just seems to skip this line. No error messages or anything. I'm using it like this:

Please Login or Register  to view this content.