Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing a file
How can I limit the number of lines when importing a file? Limit the import
to the first 53 lines of a file that has 50,000+ lines. Want to import the first "XX" set of lines, then I want to skip a set of lines, then continue to import the rest of the lines. The second import needs to be inserted 2 or 3 lines down from the first import. There is the function: Workbooks.OpenText Filename:= But it only has a StartRow and can not specify the "EndRow". Also can not specify where to start in the worksheet, i.e. Cell A5 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
Importing Text File Data into Excel where records span several row | Excel Discussion (Misc queries) | |||
Importing a csv file | Excel Discussion (Misc queries) | |||
importing csv file | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) |