View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default 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!