VBA Runtime Error 438 saving a Excel 95/2003 as FT 50 (2010)...

Hello everyone,

Title should read Excel 97/2003... UGH, sorry:
After hours of prepping a formula for a monthly roster (that I actually pull 5-9 times a month), I reached a resolve, only to run into a problem on my final approach; saving the file into a Excel 2010 format. Here is my VBA Macro formula:

HTML Code: 

My research leads to a registry edit to fix the runtime error, but being in the military, registry tweaks are a no-go due to security settings; even if I wanted to, I couldn't change them. I even tried:

HTML Code: 

Still a no-go. Maybe it's the FileFormat:=50, I don't know. All I know, is I don't want to save a Office 97/2003 File as a 2010 then run a Macro. I'd rather do it all in one Macro. Is this even feasible? Please advise.