| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause Macro For Start Row While Parsing a Text File
Thanks Tom.
"Tom Ogilvy" wrote: The code imports the file. The parameters are specified in the arguments. There is no provision for viewing the file and selecting a start row. That is provided in the Text import wizard itself. So if you want to browse the file in code and not use the text import wizard, you would have to write the routine to browse it. -- Regards, Tom Ogilvy "Bill Foster" <Bill wrote in message ... It is fairly easy to use the macro recorder to quickly parse a text file consistently. But what syntax do I need if I want the macro to pause in order to allow me to "browse" the file to edit the Start Row of the data in the text file to be parsed. For example, I have one report that has two sections. The report varies in length each time. I only want to import the data beginning at the second section, row 2485 in today's instance. Tomorrow, if there is little data, I may want to start at row 75. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing a text file to a excel or word form | Excel Programming | |||
| Issue with parsing text file into worksheet | Excel Programming | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| Parsing imported text file with macro... help! | Excel Programming | |||
| NEED EXCEL MACRO TEXT-PARSING GURU! | Excel Programming | |||
Threaded Mode
