range array

J

JJF

There is any way to use this code

Set rngArray = Range("xxx")
arrCodes = rngArray.Value

also for file csv?

I'd like to import into variant array a range from this kind of file.
Any idea?

tya
 
B

Bob Phillips

If you open a csv file in Excel like any other workbook, you can treat it as
a workbook, and do things such as that.
 
J

JJF

If you open a csv file in Excel like any other workbook, you can treat itas
a workbook, and do things such as that.

--
__________________________________
HTH

Bob










- Show quoted text -
Click to expand...


and how to import all range all at once into variatn variable?
cause it will get all the entire row, and i'd need the "split"
 
Top