Re-worked Workbook_Open, Creating DateStrings
First thought: It feels really rewarding to see a new User who takes on advice that's offered and proactively uses it to improve.

Second thought: MUCH, MUCH better. Now if you (or somebody else) ever has to come back to this code, it's going to be crystal clear what everything does and how it all works. 

One more improvement:
Stop this right now.

Dim strTableTitle       As String
Dim StrTodaysDate       As String
Dim StrThisDay          As String
Dim StrThisMonth        As String
Dim StrThisYear         As String

Dim strSaveFileFolder   As String
Dim StrSaveFilename     As String
Dim StrSaveDate         As String


I  get it, it looks really pretty. I was exactly the same when I started. Here's the thing though good code isn't pretty. Clear, concise, consistent, tidy, but not necessarily pretty. Pretty takes time. Time that could be spent actually improving your code. 

Plus, if you ever change any of those variable names, it's going to be a real pain getting it all to line up again, especially if you write one that's longer than the current ones.