VBA excel read random line from text file

[VBAxxx]

Hi,

I have flat text file
I need to read random line from txt file and put into cell

I have code :

Please Login or Register  to view this content.

---------- or code :

Please Login or Register  to view this content.

[tigeravatar]

VBAxxx,

Welcome to the forum!
In the future, please use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here.

As to your question, it looks you have a tab delimited text file. Do you want one random part of one random line put into a single cell? Or do you want all of one random line split into a row of cells? Are there any restrictions on where the random line (and/or random part from the line) can come from in the text file?

[VBAxxx]

in the file is about 2000 lines , one value in one row , for example :
------------
Test1
Test2
Test3
Test4
----------

And I need read random line(value) from this file and paste into Excel Cell

[tigeravatar]

VBAxxx,

Give this a try:

Please Login or Register  to view this content.

[VBAxxx]

it works! , Thx ! ! ! ! !

[tigeravatar]

You're very welcome

If that takes care of your need, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[manideepa]

Hi,
tigeravatar

I am trying to extract the Information from Notepad to Excel through VBA..

My Quiery is I have some Text files.. Lets

Text1
Text2
Text3
Text4

Text1 file I need some information to be extracted (i.e.., after 20 lines my information will be there) should be extracted from 20th line till end

so could you please help me out in this Waiting for your reply and code..

Thanks
Mani deepa