| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump straight to specific row number 1,234,567 (within a Text File
Via VBA code, is it possible to jump straight to a specific row number within
a ".txt" file? My database is 250MB in size. There are 4 million rows in it. Presently, my macro cycles through from top to bottom, then repeat cycle until every listed part number is found. This is pain staking. Pls show me the codes, if any. -- Edmund (Using Excel 2000) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump straight to specific row number 1,234,567 (within a Text File
try skipline
For i = 0 to 4 StdIn.SkipLine Next lg Robin Edmund schrieb: Via VBA code, is it possible to jump straight to a specific row number within a ".txt" file? My database is 250MB in size. There are 4 million rows in it. Presently, my macro cycles through from top to bottom, then repeat cycle until every listed part number is found. This is pain staking. Pls show me the codes, if any. -- Edmund (Using Excel 2000) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump straight to specific row number 1,234,567 (within a Text File
Edmund,
How are you using your text file in Excel/VBA ? Depending on the above, SEEK may be an option. NickHK "Edmund" wrote in message ... Via VBA code, is it possible to jump straight to a specific row number within a ".txt" file? My database is 250MB in size. There are 4 million rows in it. Presently, my macro cycles through from top to bottom, then repeat cycle until every listed part number is found. This is pain staking. Pls show me the codes, if any. -- Edmund (Using Excel 2000) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump straight to specific row number 1,234,567 (within a Text File
Why don't you use a database to store your database?
MH "Edmund" wrote in message ... Via VBA code, is it possible to jump straight to a specific row number within a ".txt" file? My database is 250MB in size. There are 4 million rows in it. Presently, my macro cycles through from top to bottom, then repeat cycle until every listed part number is found. This is pain staking. Pls show me the codes, if any. -- Edmund (Using Excel 2000) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Tab key to jump to specific cell | Excel Discussion (Misc queries) | |||
| Text join formulas working but act as straight text when modified | New Users to Excel | |||
| Remove decimal from price to show straight number | Excel Programming | |||
| jump to hyperlink, extract value at specific destination in file | Excel Worksheet Functions | |||
| Excel should let hyperlink of PDF jump to a specific page like IE. | Excel Discussion (Misc queries) | |||
Linear Mode
