| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
| Open several text files using a macro | Excel Discussion (Misc queries) | |||
| copy text between 2 open workbooks via macro | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Recording a macro to open a large fixed-width text file | Excel Programming | |||
Threaded Mode
