Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to dynamically add a reference to personal.xls ?
I use personal.xls to perform customisation whenever I open a new
workbook. For example, I add menu items to the toolbar, which is very useful. However, if I want personal.xls subs and functions to be callable by VB code in the new workbook I first have to use the VBE Tools menu to manually add a reference to personal.xls. Is it possible to add an external reference to personal.xls programatically? I'm sure there must be a way of doing this. Guidance appreciated... Regards, John M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to dynamically add a reference to personal.xls ?
Hi,
on open: ThisWorkbook.VBProject.References.AddFromFile..... . regards, ste |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to dynamically add a reference to personal.xls ?
Thanks. Just what I was looking for. Much obliged.
Cheers, John M ste wrote: Hi, on open: ThisWorkbook.VBProject.References.AddFromFile..... . regards, ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically Reference Offline Workbook/worksheet | Excel Discussion (Misc queries) | |||
How to reference cells dynamically | Excel Discussion (Misc queries) | |||
Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Changing Reference Dynamically | Excel Programming |