How to extract file name from user selected file via Application.FileDialog

**Jpdatabase** · 09-08-2012, 05:08 PM

Hi All

Long time reader first time poster. I am trying to figure out how to extract the file name for a user selected item via the Application.FileDialog(msoFileDialogFilePicker) method. The below code prompts the user to choose an image but i can't seem to figure out how to extract the file name into a string variable. If i set .SelectedItems(1) equal to a string variable i get an error. Any ideas? Thanks.

Please Login or Register  to view this content.

**patel45** · 09-08-2012, 05:31 PM

Please Login or Register  to view this content.

**Jpdatabase** · 09-08-2012, 07:09 PM

Hi Patel45

Thanks for the quick reply. I'm a bit of a newbie to excel programming, so please excuse my slow comprehension. The code you provided extract ALL the file names from a selected folder. Is there a way to just extract the file name for a single user selected file? Also, in your variable declarations you used the '$' character. Is that a unique naming scheme?

Thanks

**Cutter** · 09-08-2012, 08:15 PM

@ Jpdatabase

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

**patel45** · 09-09-2012, 02:51 AM

Please Login or Register  to view this content.

**WasWodge** · 09-09-2012, 04:45 AM

Also, in your variable declarations you used the '$' character. Is that a unique naming scheme?

I don't know whether "unique" is the right word, just different. Have a look at the link below where it lists the type declaration characters with a bit of explanation.

http://support.microsoft.com/kb/191713