LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 3
Default Locating XLAM in same directory where XLSM is

Hi everybody!

My problem in Excel 2010 is like this :

There is an Excel file XLSM using some functions and macros containing in an XLAM file. Separate instances of this XLSM file are used by different people, each of them have an own data set in a personal file. This file can be stored on a movable medium like an USB-Stick. The file XLAM is under ongoing development and gets sometimes modified.
Now I would like to locate this XLAM file in the same directory where also the XLSM is - it means probably on a movable medium as well. The idea is that a modified XLAM can be simply downloaded by a person using XLSM and will serve it with the modified functions or macros, preserving the unique data contents of the relating XLSM. The USB stick can be taken to another computer and the XLSM will be usable with the copy of XLAM stored on the USB, even if on this computer there is some local copy of the XLAM, located in the AddIn path.

The point of my problem : How can I teach the XLSM that it should always use the XLAM stored in the same directory? -- something like "..\ABC.XLAM" without indicating the full path that may be different on different computers.

Any kindly assistance would be highly appreciated.

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
How to call a macro from a xlam in a xlsm CLDommel Excel Programming 3 November 24th 09 03:50 PM
Convert xla add-in to xlam? Richard M Excel Discussion (Misc queries) 3 February 16th 09 08:16 PM
Convert xla add-in to xlam. Richard M[_2_] Excel Programming 1 February 13th 09 11:31 AM
Listing Active Directory groups that have directory access rights [email protected] Excel Programming 0 October 17th 08 03:13 PM
Locating the directory a workbook is stored in Graham Whitehead Excel Programming 1 August 4th 06 09:47 AM

All times are GMT +1. The time now is 09:12 PM.

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

About Us

"It's about Microsoft Excel"