Re: Show Filename Only in ComboBox Pulldown

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" <ec35720@xxxxxxxxxxxxxxxxx> wrote in
> message news:42C215C7.14E6BFCD@xxxxxxxxxxxxxxxxxxxx
> 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.
>
>
>
.

Relevant Pages

  • Re: Show Filename Only in ComboBox Pulldown
    ... "Jim Cone" wrote: ... > to contain the full file path. ... > San Francisco, USA ... if there are two files (in different subfolders) that share the same ...
    (microsoft.public.excel.misc)
  • Re: Show Filename Only in ComboBox Pulldown
    ... But the original code searched subfolders, ... Jim Cone wrote: ... >> to contain the full file path. ... >> San Francisco, USA ...
    (microsoft.public.excel.misc)
  • Re: Show Filename Only in ComboBox Pulldown
    ... Kind regards, ... "Jim Cone" wrote: ... >> to contain the full file path. ... >> (or any of its subfolders). ...
    (microsoft.public.excel.misc)
  • Re: Show Filename Only in ComboBox Pulldown
    ... Change the second line of the Private Sub OKButton_Click ... Jim Cone ... > to contain the full file path. ... if there are two files (in different subfolders) that share the same ...
    (microsoft.public.excel.misc)
  • Re: Show Filename Only in ComboBox Pulldown
    ... But I'd look out for an empty combobox. ... Jim Cone wrote: ... > Change the second line of the Private Sub OKButton_Click ... >> (or any of its subfolders). ...
    (microsoft.public.excel.misc)