Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import text w/macro
I've tried recording a macro that will open a text file into Excel 2003. The
text file has over 256 columns, so while recording the macro i set some columns to be "skipped" (not imported). When i clicked "finish", i got an error message about "Too many line continuations". The text file did open fine, but when i looked at the recorded macro in VBA, the code was in red and was clearly cut off after a certain point. Is there a way i can write code/record a macro to open this text file (again, i just want to import some of the 256+ columns) that won't run into the "Too many line continuations" problem? Thanks rachael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I call up the Text Import Wizard via a macro. | Excel Worksheet Functions | |||
Macro to Import Text | Excel Discussion (Misc queries) | |||
Text Import Macro Help | Excel Programming | |||
Import text wizard in a macro | Excel Programming | |||
Creating a macro to use the text import wizard | Excel Programming |