View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default 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.