View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Irina Irina is offline
external usenet poster
 
Posts: 12
Default How change link source in long formula when source moved

Hello!
Plz, help me change link source in LONG formula when source moved or renamed.
When open workbook with such links or on the other computer, formula
damages, and change source already crashed.
Method ChangeLink of workbook object does'nt work too.
How to do my "user defined functions" Excel feels as its own?
May be, I should place my xla in a special folder?
Thank you in advance.
Irina