Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel XP: How to make a reference to a library persistent
Hi,
I need a reference to the library "Microsoft Visual Basic For Applications Extensibility". For each new document I have to check this option in the VBA editor again. Is it possible to make this option persistent? Regards, Marcel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel XP: How to make a reference to a library persistent
Hi Marcel,
It's simple. Start a new blank workbook. Go to Viusal Basic Editor and add the reference to the required library (or libraries). Save the the workbook as a Template (.xlt) giving a name you will easily remember :- e.g. 'VB-App-Ext.xlt'. Save this template in default template path (When you click on save, (or save as), in the Save window, in 'Save As Type' field (which is bottom most), click on the Down arrow and select 'Template (*.xlt). This will save the file in the default template path. Close the workbook. Whenever you want a new document with reference to the that library simply click on File Menu- Select New- Select 'VB-App-Ext.xlt'. Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel XP: How to make a reference to a library persistent
Hello Sharad,
Thank you for your solution. I thought there would be some kind of normal.dot as Word has, but this will do the job also very well. Now I can start Excel from the Alpha Five database program load a new document based on that template and create with Xbasic macro code in Excel to execute. Thanks a lot. Regards, Marcel "Sharad" schreef in bericht ... Hi Marcel, It's simple. Start a new blank workbook. Go to Viusal Basic Editor and add the reference to the required library (or libraries). Save the the workbook as a Template (.xlt) giving a name you will easily remember :- e.g. 'VB-App-Ext.xlt'. Save this template in default template path (When you click on save, (or save as), in the Save window, in 'Save As Type' field (which is bottom most), click on the Down arrow and select 'Template (*.xlt). This will save the file in the default template path. Close the workbook. Whenever you want a new document with reference to the that library simply click on File Menu- Select New- Select 'VB-App-Ext.xlt'. Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Reference Library - Missing Library in a lower version. | Excel Programming | |||
Is it possible to set a reference to a library in another file using VBA in Excel? | Excel Programming | |||
Excel library reference files | Excel Programming | |||
Excel Object Library Reference | Excel Programming |