Thank you also for all of you help and assistance!!!!!!!!!!

Kind regards,

D.Parker

"Dave Peterson" wrote:

Oops. One version of the application.filesearch had .SearchSubFolders = true.

But the one the OP is using doesn't (I think).

I think you have it...

But I'd look out for an empty combobox.

if me.combobox1.value = "" then
msgbox "Please choose a file
exit sub
else
textpath = "C:\temp\" & me.combobox1.value
end if



Jim Cone wrote:

D,

OK, one more idea...

Change the second line of the Private Sub OKButton_Click()
sub so it reads:
TextPath = "C:\Temp\" & Me.ComboBox1.Value

Jim Cone

"Jim Cone" wrote in message
...
D,
Almost anything is possible, but some of it is not worth the effort.
What you might do as an interim fix is to go back to the code
you had before Dave and I got involved, then right-align the text
in the combo box so the file name will show.
Reviewing the help file for the combobox object could prove
beneficial.
Regards,
Jim Cone
San Francisco, USA

"D.Parker" wrote in message
...
So does this mean it is not possible with the Dir function you sent me
earlier? Thank you.
D.Parker
"Jim Cone" wrote:
Another approach would be to use two columns in the combo box.
The first column to display the file name and a second hidden column
to contain the full file path.

Jim Cone
San Francisco, USA



"Dave Peterson" wrote in
message ...
If you only keep track of the filename, then excel won't know to look in c:\temp
(or any of its subfolders).

In fact, if there are two files (in different subfolders) that share the same
name, how would the user decide which is which?
I'd make that combobox bigger and show the complete path.




--

Dave Peterson