Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetOpenFilename and arrays
This may be a basic question but i cant find the answer in
any of my textbooks. I have used the GetOpenFilename method with MultiSelect set to true This means the method will return an array (which I have aready declared as a dynamic array). But i have no way of knowing how many files the user wil select. I wish to know the size of the array that is returned from the method so that I can deal with each file in turn. is there any property or function that will tell me this? If not the only way i can think of solving it is using a do loop with a until cause that stops only when the next Array(K) = "". This with a counter may work. Any ideas please? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetOpenFilename and arrays
Sorry to bother you all
Just found out about Ubound and LBound |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using filename retrieved from GetOpenFilename | Excel Discussion (Misc queries) | |||
Use of IF with arrays | Excel Worksheet Functions | |||
GetOpenFilename not returning a usable variable | Excel Discussion (Misc queries) | |||
Arrays | Excel Discussion (Misc queries) | |||
GetOpenFilename | Excel Programming |