Fill the listbox only with file name

[theDBguy]

Private Sub lstFiles_DblClick(Cancel As Integer)

fShellExecute Me.lstFiles

End Sub
Thank again

Yup! Trying to open a file with using just the filename won't work. Also, since my demo lists all the files in a folder and its subfolders, you could have duplicate filenames showing in the listbox. Double-clicking on any of them wouldn't specify which one to open. That's why you need the whole path.

 

[Gasman]

Someone was asking a similar question and Hanns showed a neat way of just getting the filename without messing with InstrRev() etc.

file Pick - name only not path - Eileen's Lounge

 

[theDBguy]

Based on @MajP comments, I have updated the demo file to use two columns, so ShellExecute would keep working.

Hope this helps...

 

[Gasman]

It doesn't works because the listbox has just one column and the name is embedded (includes also the path and file name )

Not really hard to add an extra column?

 

[gstylianou]

Based on @MajP comments, I have updated the demo file to use two columns, so ShellExecute would keep working.

Hope this helps...

Really thanks for this update. Everything works fine..!!

 

[gstylianou]

Not really hard to add an extra column?

Not really hard to add an extra column?

Means that you didn't understand what exactly is the issue..! Anyway, thank for your interest..

(Please read all the communication with theDBguy and MajP..)

 

[theDBguy]

Really thanks for this update. Everything works fine..!!

Glad we could assist. Good luck with your project.

 

[Gasman]

Not really hard to add an extra column?

Means that you didn't understand what exactly is the issue..! Anyway, thank for your interest..

(Please read all the communication with theDBguy and MajP..)

Well theDBguy managed it?