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.

But I still have the problem when I open a workbook that uses any of
the functions in the Excel 4.0 .xla, the .xla file opens. I tried
saving/upgrading the .xla file from Excel 4.0 to the current version,
but that didn't work. Like I said before the Excel 4.0 .xla file
doesn't look like a normal .xla file and I look through the code in the
rows on the worksheet and don't see any command to open the .xla file.
Another thing that bothers me is that the .xla file appears as a link
in the EditLinks... option...if it's a referenece add-in, why does it
appear in the links list. I have other custom add-ins with functions
that I call and they don't appear in the Links List. When calling the
function in the workbook, it looks somethings like this:
ODMS_Calculations.xla!GasCalc1($I$10;$J$10;$K$10;$ L$10;$M$10;B16;C16;D16)
where ODMS_Calculations.xla is the name of the .xla file and GasCalc1 is
the name of the function being called and
($I$10;$J$10;$K$10;$L$10;$M$10;B16;C16;D16) are the arguments being
passed to the .xla file. I can't figure out why it is opening the .xla
file


--
suzetter
------------------------------------------------------------------------
suzetter's Profile: http://www.excelforum.com/member.php...fo&userid=7078
View this thread: http://www.excelforum.com/showthread...hreadid=385309