Hi all
When browsing for a file with VBA, how can I read the file name of the document selected:
Example 1:
C:\Australia\Sydney\Summary.zip
--> I would like the code to return "Summary.zip"
Example 2:
C:\New Zealand\Auckland\2019\Final Slides\Presentation.zip
--> I would like the code to return "Presentation.zip"
The number of folders and string lenght can, as you see in my example, vary.
Any help is appreciated.
Thanks
FD
Use "\" as delimiter and split string.
Ex:
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
THe document selected? Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks, that worked...
but what is X in this case? like a collection?
I used x as variant, which is implicitly assigned array from split function.
I use the following functions for extracting parts of file paths:
In your case:Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks