Urgent. VBA. Need code and flowchart for 5th task.

6 https/estudijas.rtu.lv/pluginfile.php/1558214/mod_resource/content//e 12.00 5. Create text file with notepad. Each line contains only one word. Open it and, if the word begins with capital letter, output it to column A, otherwise in column B le 6. Create text file with notepad. Each line can contain only 1 word or 1 number. Open it and, if the string contains a number, output it to column A, otherwise (contains the word) in column B 7. Write function (using loops) for: 1110x+9x2+8x3 ..x10 8. Create 2d array (6*6). Fill with random numbers (range -20 to 50). Create and display one-dimensional array that consists of the average value of each initial array's row. VBA_file