I have a special database program that exports its data to a new Excel
workbook with no VBA references attached. I need this exported workbook to
have a reference in the VBE editor to ATVBAEN.xls for a macro to work. So I
set up my book.xlt template so that it has that reference, and that works
when I launch Excel by itself. Unfortunately, this exported file starts
without that reference attached. Then I noticed that the exported filename
is "Book1.xls" instead of "book1.xls" as it is when I start Excel by itself,
so somehow the exported file is getting launched differently than a standard
new file. So my attempts to attach the reference by default are not working.
Any ideas?