Hi,
I'm just trying to get the path of the selected file (by use of getopenfilename) shown in listbox5... why will it not work?
thanks!Sub Get_Data_From_File() Dim sFullName As String Dim sFileName As String ChDrive "I:" ChDir "I:\_PUR_PURCHASING\_PUR_" sFullName = Application.GetOpenFilename("*.pdf,*.pdf") sFileName = Dir(sFullName) 'Debug.Print sFullName, sFileName ListBox5.AddItem sFullName(sFullName + 1) End Sub