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.
|