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)

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)

Edmund,
How are you using your text file in Excel/VBA ?
Depending on the above, SEEK may be an option.

NickHK

"Edmund" <Edmund@discussions.microsoft.com> wrote in message
news:505B8860-108C-4E71-AB3F-40001BE76F40@microsoft.com...
> 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)

Why don't you use a database to store your database?

MH

"Edmund" <Edmund@discussions.microsoft.com> wrote in message
news:505B8860-108C-4E71-AB3F-40001BE76F40@microsoft.com...
> 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)