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)

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)

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)

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)