| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Array Limit
Excel 2003. I am using the following code to read filename(s) into a variant
array. How may I determine how many files were selected? Or how may I determine Dim Fname as Variant FName = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Select RD Workbooks to Email", , True) I get an error when I try to access FName and move beyond the last array element trying to determine how many elements (file names) there are. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Array limit? | Excel Worksheet Functions | |||
| Limit on array formula | Excel Worksheet Functions | |||
| Work around for limit on entering array formulas? | Excel Programming | |||
| does Excel have memory limit of data Array? | Excel Programming | |||
| limit to possible array size? | Excel Programming | |||
Threaded Mode
