Listbox lstFiles displays files with various extension types. To open a file on dbl-click I have the submitted code.
Question: What is the best way to open any selected file? At this time I am able to open pdf files only.
Dim strFileName as string
strFileName = Me!lstFiles.Column(1)
strFileName ="C:Folder1\" & strFileName
v-- file extention type
Case "pdf":Shell ("C:\Acrobat3\Reader\AcroRd32.exe " & strFileName), vbMaximizedFocus
' may others not listed here