OPEN.TEXT function in Excel 4.0 macro
 

I use the old Macro4.0, since I have always used it, and do not like to
try and learn VBA instread.

I have a problem picking up selected columns only from a large sheet.
The same columns seem to appear, no matter how I try.
The formula I enter is:

=OPEN.TEXT("c:\sapworkdir\pofrc0410";2;1;1;1;;;;;; 1;"|";{1\2;2\2;3\2;4\2;5\2;6\2;7\2;8\2;9\2;10\2;11 \2;12\2;13\2;14\2;15\2;16\2;17\2;18\2;19\2;20\2;21 \2;22\2;23\2;24\2;25\2;26\2;27\2;28\2;29\2;30\2;31 \2;32\2;33\2;34\2;35\2;36\2;37\2;38\2;39\2;40\2;41 \2;42\2;43\2;44\2;45\2;46\2;47\2;48\2;49\2;50\2;51 \2;52\2;53\2;54\2;55\2;56\2;57\2;58\2;59\2;60\2;61 \2;62\2;63\2;64\2;65\2;66\2;67\2;68\2;69\2;70\2;71 \2;72\2;73\2})

It is obviously the FieldInfo I have problems with.
I would like to pick up e.g. only columns 5, 10, 15 and 20.
How may I do this?


--
cvhelios
------------------------------------------------------------------------
cvhelios's Profile: http://www.excelforum.com/member.php...o&userid=19995
View this thread: http://www.excelforum.com/showthread...hreadid=345811