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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Specific Rows in Range and Create New Tab 18
AutoFill down a certain number of rows 3
Text To Columns then insert rows 9
How to Delete rows with blank or specific value in a Macro ? 1
jump to specific table 1
Run macro on all files in a specific folder 3
Apply Alternate Shading to selected rows 2
Code to Resize a variable number of rows including target 7

Back
Top