Operations on files - Excel

Copper Contributor

Hello guys I´m back with another task. I´m still terrible in using excel files, I would really apriciate some help with my university task. Thanks a lot !

 

Title: Operations on files

Task 1

Read the data from the Lab 11.txt file to a spreadsheet. The file contains data of 10 countries (their area and population). Then sort all countries alphabetically and save to file Lab 11 result.txt (you have to create it yourself). Data sorting (e.g. bubble sort algorithm) must be done using the known VBA instructions, not the MS Excel built-in functions.

 

Lab 11.txt content:

No,Country,Territory,People

1,USA,9526468,329256465

2,Canada,9984670,35881659

3,Brazil,8515767,38420687

4,Argentina,2780400,44694198

5,Russia,17098242,142122776

6,Mexico,1964375,125959205

7,Indonesia,1904569,262787403

8,China,9596960,1401585247

9,Poland,312696,38420687

10,Italy,301340,62246674

1 Reply