LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 395
Default Force increased width of GetOpenFilename dialogue box?

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_FortJ za_2010_05_NEF.xls
Charbtack_AllResources_StockRate_CreditMemos_FortJ za_2010_05_AGR.xls
Charbtack_AllResources_StockRate_CreditMemos_FortJ za_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.

 
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
Increased percentage question Brian Excel Worksheet Functions 3 May 15th 09 10:50 AM
How to force column formatting (text, date, etc) when loading a fixed width text file into an array? ker_01 Excel Programming 3 October 21st 08 08:45 PM
GetOpenFilename - dialogue box John B[_3_] Excel Programming 1 January 30th 06 03:17 PM
Can the max. number of 65,000 rows in Excel be increased? JWallCovista Excel Discussion (Misc queries) 2 May 24th 05 03:03 PM
Height Needs To Be Increased In Row Deb Setting up and Configuration of Excel 1 March 4th 05 06:50 PM


All times are GMT +1. The time now is 05:19 AM.

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

About Us

"It's about Microsoft Excel"