Populate Multi Column ListView Control with Text File (.txt)

Dear Experts!

Hope you are doing best in your life.

I have a listview control with 6 columns and have a Text file with 6 columns (All columns separated with vbTab)

I want to import it into a ListView control.

Please guide me accordingly

I shall be very thankful to you.

Hello AmirSoft,

This macro lets the user select a file to open. The macro is set to view 6 columns of tab delimited data in the file. The name of the ListView control is "ListView1". Yo may need to change this if your control has a different name. Copy and paste this macro to a VBA Module in your workbook's project.

Please Login or Register  to view this content.

Thank you so much for your reply

I made an example file. Please check this and guide me.
in this file a userform have two listview controls. From List one save the data to txt file
and load list two from that txt file in report view.

Shall be very thankful to you.

Amir

Hello AmirSoft,

The attached workbook has 2 new macros: ImportTextFile and ExportTextFile. The text file is named "Stock Balance.txt" and is saved in the same directory as the workbook. These macros are called by Command Buttons 5 and 6, respectively. Here is the code...

Module1 Macros

Please Login or Register  to view this content.

Dear Leith Ross!

Thank you so much. You did really a great work.

I have an other thread. But it is still unsolved.
https://www.excelforum.com/excel-pro...ml#post4929444

If you have some time then please take a look on above link. and guide me it is possible or not.
If this is possible then please guide me.

I shall be very thankful to you.