View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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)