Hi, I wrote a bunch of custom functions in VBA. I saved them by context into
XLA files. For example, I had project correlations and module1 in it with
dozen of functions. Thera are also other XLA files like conversion project
etc.
So there is a xla file for each project. I saved all my xla files (for.
example correlations.xla, conversion.xla) in e:\prj\MyAddins directory.
Second, I made a book called all-correlations.xls which used all of the
custom made functions. Some of the cells were pasted from other books (which
used few of mentioned custom VBA functions)
That all worked well, and when I tested it I saved it to my boss's desktop.
When he opened the file (all-correlations) he choosed add-ins related to
book, but formulas in sheets were messed up.
It remembered my local path to addins (c:\prj\myaddins) with the drive
letter changed to c:
What was my mistake, and how to avoid this?