Xla file being referenced in the cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When say user1 creates report and saves it to his local machine, the
functions refernceed in the cells are saved using an absolute address.


Like cell B11, will be referenced as
='C:\Program Files\microsoft
office\OFFICE11\xlstart\ConsolidationAddin.xla'!getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)

If user1 sends this saved report workbook to another user2, whose
excel installation is different from the original developer, The report
cannot be used unless the absolute address is mass replaced on all the
worksheets of the workbook as for this user the consolidation.xla files will
be at different location.

Can you please help inresolving this issue.

Thanks, Sandeep
 
You could have the recipient use
Edit|Links|Change source

To point at their location of the addin.

To make life easier, you may want to tell everyone to use the same folder on the
same drive (and the same filename).

Include a note to all the recipients that they have to store the addin in:

C:\SandeepUtils\ConsolidationAddin.xla

Then they can use Tools|Addins to browse for this and install it.
 
How can we change the cell reference in each cell from
='C:\Program Files\microsoft
office\OFFICE11\xlstart\ConsolidationAddin.xla'!getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)

to

=getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)

programatcally? Can you please give me a sample code for this?

thanks,
Sandeep
 
Record a macro when you go through the Edit|Links|Change source and make sure
that the addin is in a folder that shares a common name for all the users.
 
Back
Top