Hello and welcome to the forum starcraftbud! Great first post.
According to the [URL="http://www.datawatch.com/downloads/Monarch_8_Programmers_Guide.pdf"]Monarch Programmer's Guide[/URL], the problem isn't your models, or your code, per se, but in what the .ExportTable method actually does.
In order to use newer file formats supported by later versions of Monarch, use JetExportTable (Professional version only, V6 or greater).[/QUOTE]
If you have v6 Pro, then great, change to use .JetExportTable and you're in business.
Otherwise a change in direction might be necessary.
I ran into similar issues when using Monarch v5 Standard with Excel 2003 when I first became a member of this forum almost eight years ago (holy moley... :eek:).
IIRC, my workaround involved exporting to CSV files and then importing those files into Excel, steps that I incorporated into my VBA code such as you're doing.