D,
Use the "Dir" function...
'-----------------------------
Sub FileNameTest()
Dim strPath As String
Dim strName As String
strPath = "C:\Program Files\Intel\Intel Application Accelerator\iATAenu.dll"
strName = Dir(strPath)
MsgBox strName
End Sub
'-----------------------------
Jim Cone
San Francisco, USA
"D.Parker" wrote in message
...
This is an continuation post from 6/26. JMB showed me the code to add to
utilize FileSearch inconjunction with UserForms. The code works great,
unfortunately the entire "path" (C:\.....\<filename.txt) shows up in my
combobox pull down. Is there a way to show only the filename and not the
actual path to the file in the combo box?
Kind regards,
D.Parker
|