1. Develop a solution, in which it must be use the code of figure #3 as example to created import data from a Text file an convert to Excel data file via VBA programing
2. Show flowchart and pseudocode must be present in the report.
3. Total value 30 Points.
4. For due dates refer to Calendar located on the Tools menu in Blackboard.

Problem: AWN Using the code of Eigure 3 Code in other to convert the data .txt file in to Excel data File in to TEXT data files. Click the image to download data. data - Notepad File Edit Format View Help First Name Last Name Gender Country Age Date Id 1 Dulce Abril Female United States 32 15/10/2017 1562 2 Mara Hashimoto Female Great Britain 25 16/08/2016 1582 3 Philip Gent Male France 36 21/05/2015 2587 Kathleen Hanner Female United States 25 15/10/2017 3549 5 Nereida Magwood Female United States 58 16/08/2016 2468 6 Gaston Brumm Male United States 24 21/05/2015 2554 7 Etta Hurn Female Great Britain 56 15/10/2017 3598 8 Earlean Melgar Female United States 27 16/08/2016 2456 9 Vincenza Weiland Female United States 40 21/05/2015 6548 Fallon Winward Female Great Britain 28 16/08/2016 5486 11 Arcelia Bouska Female Great Britain 39 21/05/2015 1258 Franklyn Unknow Male France 38 15/10/2017 2579 13 Sherron Ascencio Female Great Britain 32 16/08/2016 3256 14 Marcel Zabriskie Male Great Britain 26 21/05/2015 2587 15 Kina Hazelton Female Great Britain 31 16/08/2016 3259 16 Shavonne Pia Female France 24 21/05/2015 1546 17 Shavon Benito Female France 39 15/10/2017 3579 18 Lauralee Perrine Female Great Britain 28 16/08/2016 6597 19 Loreta Curren Female France 26 21/05/2015 9654 20 Teresa Strawn Female France 46 21/05/2015 3569 21 Belinda Partain Female United States 37 15/10/2017 2564 22 Holly Eudy Female United States 52 16/08/2016 8561 Many Cuccia Female Great Britain 46 21/05/2015 5489 ,24 Libbie Dalby Female France 42 21/05/2015 5489 10 12 23 Problem: AWN Using the code of Eigure 3 Code in other to convert the data .txt file in to Excel data File in to TEXT data files. Click the image to download data. data - Notepad File Edit Format View Help First Name Last Name Gender Country Age Date Id 1 Dulce Abril Female United States 32 15/10/2017 1562 2 Mara Hashimoto Female Great Britain 25 16/08/2016 1582 3 Philip Gent Male France 36 21/05/2015 2587 Kathleen Hanner Female United States 25 15/10/2017 3549 5 Nereida Magwood Female United States 58 16/08/2016 2468 6 Gaston Brumm Male United States 24 21/05/2015 2554 7 Etta Hurn Female Great Britain 56 15/10/2017 3598 8 Earlean Melgar Female United States 27 16/08/2016 2456 9 Vincenza Weiland Female United States 40 21/05/2015 6548 Fallon Winward Female Great Britain 28 16/08/2016 5486 11 Arcelia Bouska Female Great Britain 39 21/05/2015 1258 Franklyn Unknow Male France 38 15/10/2017 2579 13 Sherron Ascencio Female Great Britain 32 16/08/2016 3256 14 Marcel Zabriskie Male Great Britain 26 21/05/2015 2587 15 Kina Hazelton Female Great Britain 31 16/08/2016 3259 16 Shavonne Pia Female France 24 21/05/2015 1546 17 Shavon Benito Female France 39 15/10/2017 3579 18 Lauralee Perrine Female Great Britain 28 16/08/2016 6597 19 Loreta Curren Female France 26 21/05/2015 9654 20 Teresa Strawn Female France 46 21/05/2015 3569 21 Belinda Partain Female United States 37 15/10/2017 2564 22 Holly Eudy Female United States 52 16/08/2016 8561 Many Cuccia Female Great Britain 46 21/05/2015 5489 ,24 Libbie Dalby Female France 42 21/05/2015 5489 10 12 23