Urgent. VBA. Need code for 5th task.

6 https/estudijas.rtu.lv/pluginfile.php/1558214/mod_resource/content/1/exam.pdf 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+9x+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