In message of Mon, 4 May 2009
17:27:05 in microsoft.public.excel.programming, Ron de Bruin
writes
Hi Water, see also :
http://www.rondebruin.nl/personal.htm


I saw that and was much impressed. I am still in the process of
digesting it. Application.StartupPath will be very useful to me.
I did some experimentation and found that if
"Application.StartupPath"\Personal.xls does not exist, Personal.xls is
opened from another folder - I infer by all users. For me, that folder
is "C:\Program Files\Microsoft Office\OFFICE11\XLSTART". I don't think
it very useful, but it seems worth putting on the record in the absence
of documentation from Microsoft. Curiously, Sysinternals' procmon.exe
does not seem to notice the double (and possibly longer) search. I don't
care enough to investigate further.

The advice from "royUK " and "Peter T
" to use an add-in seems good and I will
look at that when I have time.

Thank you all! THAT problem is solved and my understanding is enhanced.
--
Walter Briscoe