Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PhilBarnes
- Order by date
-
Setting Array to Nothing
Thanks for the additional option Tony. Seems that if I use EOF as a flag I can then declare my array if the file has values and leave it empty if not.- PhilBarnes
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Setting Array to Nothing
thanks for the info xlbo. When you mentioned EOF/ BOF it got me thinking and below solved it: If Not EOF(1) Then y = 1 ReDim panelists(300) Do While Not EOF(1) ' Loop until end of file. Line Input #1, panelists(y) ' Add Mnemonic to array...- PhilBarnes
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Setting Array to Nothing
Here is my problem: ReDim panelists(300) y = 1 Do While Not EOF(1) ' Loop until end of file. Line Input #1, panelists(y) ' Add Mnemonic to array y = y + 1 Loop If IsArray(panelists) Then ReDim Preserve...- PhilBarnes
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
