Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I distribute Workbook with VBA code and library references to other computers
Hi,
I have a Workbook that I have built some useful tools into and am sending it a few of my friends to use. The problem is that the macros and other utilities I have reference some libraries that are not on the other computers. Is there a tool/method that I can use to identify all the references and make sure that when I send them my workbook file they will be able to use all the functions rightaway....sort of a build a simple install routine with the references. Thank you, VJ. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I distribute Workbook with VBA code and library references to other computers
Hi
You can open the file in Excel 97 and set the references and save the file. The references will be updated automatic when you runit in a higher Excel version. Or use binding http://www.erlandsendata.no/english/...baoleolebasics -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "vrj " wrote in message ... Hi, I have a Workbook that I have built some useful tools into and am sending it a few of my friends to use. The problem is that the macros and other utilities I have reference some libraries that are not on the other computers. Is there a tool/method that I can use to identify all the references and make sure that when I send them my workbook file they will be able to use all the functions rightaway....sort of a build a simple install routine with the references. Thank you, VJ. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Library references | Excel Programming | |||
change VBAProject References Library | Excel Programming | |||
Object Library References | Excel Programming | |||
Object Library References | Excel Programming | |||
preserving type library references when distributing macros | Excel Programming |