The data actually pouplates till AS column.When the report is generated it
stops at cloumn AL.
Does this array thing has to do anything about it?
Application.StatusBar = Please Wait.Loading Trim(Prod) Data
File
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows,
What does the following code do?especially the array part!
Application.StatusBar = Please Wait.Loading Trim(Prod) Data
File
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote,
excel is opening a text File
the array are data for column index and length of string string to be
converted to a cells
Array(Array(1, 2), Array(2, 4))
text file contents: ABCDEFG
converted to 2 columns
column 1 = AB
column 2 = CDEF
If you use [Text To Column] ( of DATA menu) you will
