Great you found the answer. Hey, just a suggestion since I see you're using the date in your file name. Instead of Format(Date, "mmddyy"), consider Format(Date, "yyyymmdd").
1) Is it Y2K compliant (many IT depts. will not accept two-year digits in anything now).
2) When you use File Manager or Windows Explorer and sort by file name, the file names will sort by year, then month, then day properly. In the other way, they'll sort by month then day then year. Not a typically desired sort. You'll end up with all Januarys for X years first, then all Februarys, etc. instead of one year first then by its months and days, then the next year, etc.
Michigan Dept. of Environmental Quality, Air Quality Division