Import specific line from external data

[Marco-Kun]

Hello everyone,

I was wondering how I can import a specific line from an external file.
The code in the added example comes from this post:
http://www.excelforum.com/word-progr...al-data.html#5

Save both files in the same location, open the doc file and press the Test_Field text box.
On this form load the external data. This will load the first line from the external file.

How can the code be changed so it loads the second line from the external file? Or the third, etc.

This is the code to import the file:

Please Login or Register  to view this content.

Kind regards,

Marco

[macropod]

Perhaps you could explain what you're trying to achieve? With what I've provided so far, there is no need for the data to be on separate lines. FWIW, your previous code already had the logic for reading multiple lines from a text file but I removed it as the approach I posted only requires a single data line (consistent, in fact, with what your code aimed to achieve with the Const declaration)

[Marco-Kun]

I added an example how it worked before the changes. This still requires the trusted access, of course.
With this it was possible to have multiple listbox entries with one external source.
If you open the form, depending on the selection in ListBox1 (Test1), other entries will be loaded in ListBox2 (Test2).

I was wondering if that's possible with your code as well? Or should I go for multiple external data files?

Kind regards,

Marco

[macropod]

For one possible approach, see attached.

[Marco-Kun]

Thanks for the reply.
With that it shows the 2 lines over the 2 listboxes.
What I would like to have is, depending on what the selection is in ListBox1, import another line in ListBox2.

So let's say in the External Data file this is present:

Please Login or Register  to view this content.

In ListBox1, line 1 should be imported.
Whenever someone picks number 1, line 4 should be imported in ListBox2 (A, B, C)
If someone picks two, line 7 should be imported in ListBox2, etc.

I want to specify in the import code which line should be imported from the text file.

I can make the conditions, I only would like a code where I can specify the line to import.

Kind regards and thanks for the time.

Marco

[macropod]

It would be more trouble than it's worth to conditionally read the file. What you can do is to load all the data into a string variable or array, then conditionally populate a listbox with the portion you're interested in. See attached. Note the data re-arrangement in the text file - and the way they're processed.