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, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,
Semicolon:=False, _
Comma:=False, Space:=False, Other:=True, OtherChar:=~, FieldInfo:=
_
Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 2), Array(5,
2), Array(6, 2), _
Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2), Array(11,
2), Array(12, 2), _
Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1),
Array(17, 1), Array(18, 1), _
Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1),
Array(23, 1), Array(24, 1), _
Array(25, 1), Array(26, 1), Array(27, 1), Array(28, 1),
Array(29, 1), Array(30, 1), _
Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1),
Array(35, 1), Array(36, 1), _
Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1),
Array(41, 1), _
Array(52, 2))
On Wed, Mar 16, 2011 at 12:56 AM, STDEV(i) setiyowati.d...@gmail.comwrote:
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 understand this code.
CMIIW
On Wed, Mar 16, 2011 at 12:04 AM, Skanda skanda.pokkun...@gmail.comwrote:
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, ConsecutiveDelimiter:=False, Tab:=True,
Semicolon:=False, _
Comma:=False, Space:=False, Other:=True, OtherChar:=~,
FieldInfo:= _
Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 2), Array(5,
2), Array(6, 2), _
Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2),
Array(11, 2), Array(12, 2), _
Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1),
Array(17, 1), Array(18, 1), _
Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1),
Array(23, 1), Array(24, 1), _
Array(25, 1), Array(26, 1), Array(27, 1), Array(28, 1),
Array(29, 1), Array(30, 1), _
Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1),
Array(35, 1), Array(36, 1), _
Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1),
Array(41, 1), _
Array(52, 2))
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel