Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to create a file open box using a dialog box
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
File Browse Function (Open dialog box for choosing file) | Excel Programming | |||
File Open Dialog | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming | |||
File open dialog | Excel Programming |