Force increased width of GetOpenFilename dialogue box?

K

ker_01

I use the following line in several procedures in a workbook

newFN = Application.GetOpenFilename(FileFilter:="Excel-Compatible Files,
*.xls;*.xlsx;*.xlsm;*.csv", Title:=TitleString)

The source files are produced as reports from various servers, and often
have very long names (I don't have control over the file naming convention).
Thus, the user might have to select a file from:

Charbtack_AllResources_StockRate_CreditMemos_FortJza_2010_05_NEF.xls
Charbtack_AllResources_StockRate_CreditMemos_FortJza_2010_05_AGR.xls
Charbtack_AllResources_StockRate_CreditMemos_FortJza_2010_05_PFW.xls

The standard GetOpenFilename dialogue is not wide enough to show the tail
end of the filenames (the only place to distinguish which file is needed), so
each time the user opens a file, they have an extra step of manually widening
the dialogue box before selecting a file.

Is there any way to set the dialogue box to be wider using VBA?

I realize this isn't a showstopper for the overall project, but I think the
result would be superior if I can eliminate nuisance steps for the users.

I appreciate any advice,
Keith

Current users are all on XL03, but may expand the usergroup and share the
file with XL07 users as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code corrupts file (XL2003) 3
ChDrive and ChPath to a network drive 4
GetOpenFilename - dialogue box 1
File Open Dialogue Box to a Specified Location 1
Small problem with GetopenFileName 4
rename active sheet based on cell 2
Suppress hyperlink Dialogue box when clicking on Link 1
A workbook of macros which runs on external workbooks. 6

Top