VBA excel read random line from text file

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.

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,

Give this a try:

Please Login or Register  to view this content.

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