View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Want to create a file open box using a dialog box

Hi Mike

Header yes, notes no:

Sub test()
Dim V As Variant
V = Application.GetOpenFilename(Title:="Go on pick one")
If V = False Then Exit Sub 'cancelled
MsgBox "You chose " & CStr(V)
'note that it doesn't open the file, VBA must open it if desired
End Sub

HTH. Best wishes Harald

"HpyTrvlr69" wrote in message
...
I would like to create a file open box using a dialog box, but am not
familiar with VBA. Is there a simple solution which will allow me to
change
the box header and place notes within the box itself?? Sorry for the
ignorance.

Truely,
Mindless Mike