Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use macro code from external xls file
Hello
We are distributing an Excel based application which contains a number of spreadsheet files. Currently, the main vba code logic is ina perosnal.xls file in the XLSTART directory. However, when we distribute the files we may have a problem putting a file in thid directory for users - and we only want to apply the macros to our own spreadsheets. So is there a way that we can simply have a spreadsheet with vba code within it and then get other spreadsheets to look for this external file - which will basically be in the same path? ie we have file1.xls and file2.xls in say C:\SomePath We copy vbastuff.xls into this same directory. Then file1.xls and file2.xls should then be able to use the vba functions etc in vbastuff.xls. That sort of idea anyway. How can we do this sort of thing? Angus Comber |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use macro code from external xls file
toolsoptions, general tab "optional startup file Location".
-- John johnf202 at hotmail dot com "Angus Comber" wrote in message ... Hello We are distributing an Excel based application which contains a number of spreadsheet files. Currently, the main vba code logic is ina perosnal.xls file in the XLSTART directory. However, when we distribute the files we may have a problem putting a file in thid directory for users - and we only want to apply the macros to our own spreadsheets. So is there a way that we can simply have a spreadsheet with vba code within it and then get other spreadsheets to look for this external file - which will basically be in the same path? ie we have file1.xls and file2.xls in say C:\SomePath We copy vbastuff.xls into this same directory. Then file1.xls and file2.xls should then be able to use the vba functions etc in vbastuff.xls. That sort of idea anyway. How can we do this sort of thing? Angus Comber |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to insert a hyperlink to external file | Excel Discussion (Misc queries) | |||
How to code the Macro to save and close a file? | Excel Discussion (Misc queries) | |||
How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
Macro VBA code to name Save-As file | Excel Worksheet Functions | |||
Macro code for INI file | Excel Programming |