![]() |
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