Jump straight to specific row number 1,234,567 (within a Text File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
How are you using your text file in Excel/VBA ?
Depending on the above, SEEK may be an option.

NickHK
 
Back
Top