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
|