ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File Launching and References Problem (https://www.excelbanter.com/excel-programming/345850-file-launching-references-problem.html)

Stratuser

File Launching and References Problem
 
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?


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com