opening a filedialog window

[Zygoid]

Hi All,

i am trying to get a commandbutton_click to open a filedialog box for
c:\greg\bids

Windows.Application.FileDialog.Show "c:\greg\bids\"

maybe a filedialog box is not what i think it is.
address c:\greg\bids
and should show all the files in that folder?

Thanks in advance for any help.

 

[dcronje]

Try


Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.InitialFileName = "c:\greg\bids\"
fd.Show

you will need to tell what it must do with the selected file thoug

 

[Zygoid]

ahh, works great! Thanks.

just when i think i've learned enough to handle something easy lik
this I end up pulling out a few strands of hair. :-