Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increased percentage question | Excel Worksheet Functions | |||
How to force column formatting (text, date, etc) when loading a fixed width text file into an array? | Excel Programming | |||
GetOpenFilename - dialogue box | Excel Programming | |||
Can the max. number of 65,000 rows in Excel be increased? | Excel Discussion (Misc queries) | |||
Height Needs To Be Increased In Row | Setting up and Configuration of Excel |