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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Array Limit
Hi
have a look at UBound in the VBA help -- Regards Frank Kabel Frankfurt, Germany "Chaplain Doug" schrieb im Newsbeitrag ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Array Limit
Frank Kabel wrote:
Hi have a look at UBound in the VBA help More specifically, since it might not be apparent from the On-line help: UBound(myArray) - LBound(myArray) + 1 Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Array Limit
Thank you Alan and Frank. God bless.
"Alan Beban" wrote: Frank Kabel wrote: Hi have a look at UBound in the VBA help More specifically, since it might not be apparent from the On-line help: UBound(myArray) - LBound(myArray) + 1 Alan Beban |
Reply |
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 |