Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Dialog Box to return Selected File Path and Not Open it. DMS Excel Programming 4 January 26th 10 12:46 PM
File Browse Function (Open dialog box for choosing file) b-123 Excel Programming 1 August 25th 05 10:06 PM
File Open Dialog scantor145[_3_] Excel Programming 1 September 29th 04 12:04 AM
open file dialog-select file-import worksheet Divinedar Excel Programming 1 January 16th 04 07:13 PM
File open dialog Jan Kronsell[_2_] Excel Programming 1 September 5th 03 08:56 AM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"