xlstart .xla automatically opens when starting Excel 2003
 

I have a couple of workbooks that use the same custom functions an
sub-procedures. In order to make these functions and subs visible t
all the worksheets, I followed standard advice and saved them a
add-ins, but first I changed the names of these workbooks from th
generic "VBAProject" to something appropriate ("ODMS_Functions" an
"ODMS_Calculations") and then saved them as .xla files. According t
the research I had done, I had to add these add-ins as a reference fo
each workbook that would need to see them by using th
ToolsReferences... menu item. But unless I placed the new .xla file
in the C:\Program Files\Microsoft Office\OFFICE11\XLSTART\ o
C:\Documents and Settings\-username-\Applicatio
Data\Microsoft\Excel\XLSTART file path, I would have to browse for the
manually. So I closed Excel, copied the .xla files into the C:\Progra
Files\Microsoft Office\OFFICE11\XLSTART\ folder and then opened Exce
again. I then opened the workbooks that would be using the function
and subs in the .xla files, opened the Visual Basic window, used th
Tools/References... option and selected the add-ins. I saved the file
and everything seemed to be working fine until the next time I opene
Excel, one of the .xla files opens automatically whenever I star
Excel. I checked and realized that that particular .xla files was don
in Excel 4.0 and the other .xla files which were done in Excel 200
don't open. The only way to prevent the .xla file from loading is t
remove it from the C:\Program Files\Microsoft Office\OFFICE11\XLSTART
folder, but I want to keep it in that folder so no matter who logs on
the .xla files will load, so when the user opens a workbook that use
any of the functions or subs in them, it will know where to find them
Even when I close the .xla file and then open one of the workbooks tha
use it, the .xla file opens back up. I don't know much about this ol
Excel 4.0 .xla file becasue it was done by someone else. It doesn'
look like a normal .xla file at all...when it opens all the code is o
a worksheet and I can't make make heads or tails of it. Is it possibl
that in there somewhere there is code to open itself when a workboo
references one of its functions? Any help on this puzzle will b
appreciated

--
suzette
-----------------------------------------------------------------------
suzetter's Profile: http://www.excelforum.com/member.php...nfo&userid=707
View this thread: http://www.excelforum.com/showthread.php?threadid=38530

xlstart .xla automatically opens when starting Excel 2003
 

Hi,
Excel-Link and VBA-Reference retrieve source files respectively
by a different method. They sometimes conflict.
I suppose that we should use Excel-Link for functions used in worksheets
and place xla-files in Excel-Library folder that is returned by
Application.LibraryPath. It may be less troublesome.

--
HTH,
okaizawa

suzetter wrote:
I've since figured how to prevent the .xla from opening when I start
Excel. I created a folder C:\ODMS\XLSTART\ and moved the .xla files
here. I then opened the workbooks and changed the reference to where
the .xla files are in the new location, updated the links in the
workbooks and finally deleted .xla files in the C:\Program
Files\Microsoft Office\OFFICE11\XLSTART\ folder.