LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default .xls file keeps referenced addin(.xla) filepath?

Hi

I seem to get a problem with conflicting addins references in excel. I have created an .xla file (addin) that is referenced in *each* of my user's pcs. They don't necessarily have the .xla file saved in the same directory thought (usually in the /macrolib directory but in the french version of office it's the /library directory). When coworkers exchange .xls files that reference my .xla, they sometimes get conflict excel errors. Excel tries to link the macro calls to the original .xla filepath, while it should be using the one referenced in the current machine. Excel seems to remember where the original .xla file was situated on the original pc, and doesn't automatically use the one on the current machine if paths are different.

It must be that the .xls file remembers where its macros' .xla file are situated. How can I make my .xla file uniformely used on every user machine even if the filepaths were different? Can I access the .xls file's addins paths and change them to the correct path

Thanks guys
C.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Xla file being referenced in the cell Sandeep Excel Discussion (Misc queries) 3 July 11th 07 11:44 AM
How I know if a file is using a custom addin Rodrigo Ferreira Excel Discussion (Misc queries) 3 September 15th 06 02:44 PM
How I know if a file is using a custom addin Rodrigo Ferreira Excel Worksheet Functions 1 September 15th 06 02:08 AM
Changing the name of a referenced file Colleen[_2_] Excel Programming 1 December 12th 03 06:54 PM
Selecting File and FilePath Peter Harrison Excel Programming 2 November 7th 03 04:27 PM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"