Unfortunately no time to help with your code  today. For online courses,
do a Google on "vba excel  online tutorial". You will find many options
available to you, of which some are free of charge as well.

Speaking of Google and searching, Google is great for finding example
code, and the Google Usenet search works  great in *excel* newsgroups.
Lastly, your first question  came up about a week/two weeks ago in this
forum. Try searching the posts for the last month or so, and you will
find discussions about accessing the FSO and opening files, etc.