array questions
- From: "Gary Keramidas" <GKeramidasATmsn.com>
- Date: Thu, 1 Dec 2005 01:04:33 -0500
for some reason, arrays just don't work like i think they should, so i need
some help
i have an array of file names
arr = Array("File1.xls", "File2.xls", "File3.xls")
why doesn't this open them
For i = LBound(arr) To UBound(arr)
Workbooks.Open Filename:=arr(i), ReadOnly:=True, UpdateLinks:=3
arr(i) contains "file1.xls", but i get an error
--
Gary
.
- Prev by Date: RE: Importing data from multiple closed workbooks
- Next by Date: Re: Excel crashes when program changes VBComponent name: Excel bug or what?
- Previous by thread: Questions on passng data between UserForm, Module
- Next by thread: Re: array questions
- Index(es):