close
I've long used a customized Personal.XLS worksheet which contains a number
of personalized macros, buttons, toolbars, etc..

I installed Office 2003 on my replacement computer. I assumed I'd simply
copy the Personal.XLS file from its position in
C:\Docs amp; Settings\Username\App Data\Microsoft\Excel\XLStart over to the
corresponding position on the new computer.

But I still end up with the canned opening worksheet as before the change.
What else should I be doing?

--
PT
Move the file Book.xlt in the Excel start directory (where Personal.xls is
as well).

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;PTquot; gt; wrote in message
...
gt; I've long used a customized Personal.XLS worksheet which contains a number
gt; of personalized macros, buttons, toolbars, etc..
gt;
gt; I installed Office 2003 on my replacement computer. I assumed I'd simply
gt; copy the Personal.XLS file from its position in
gt; C:\Docs amp; Settings\Username\App Data\Microsoft\Excel\XLStart over to the
gt; corresponding position on the new computer.
gt;
gt; But I still end up with the canned opening worksheet as before the change.
gt; What else should I be doing?
gt;
gt; --
gt; PT
gt;
gt;
I copied Book.xlt and personal.xls to the XLStart folder. No change - still
getting the default opening

*************************************************
quot;Bob Phillipsquot; gt; wrote in message
...
gt; Move the file Book.xlt in the Excel start directory (where Personal.xls is
gt; as well).
gt;
gt;
gt; quot;PTquot; gt; wrote in message
gt; ...
gt;gt; I've long used a customized Personal.XLS worksheet which contains a
gt;gt; number
gt;gt; of personalized macros, buttons, toolbars, etc..
gt;gt;
gt;gt; I installed Office 2003 on my replacement computer. I assumed I'd simply
gt;gt; copy the Personal.XLS file from its position in
gt;gt; C:\Docs amp; Settings\Username\App Data\Microsoft\Excel\XLStart over to the
gt;gt; corresponding position on the new computer.
gt;gt;
gt;gt; But I still end up with the canned opening worksheet as before the
gt;gt; change.
gt;gt; What else should I be doing?
Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
Type this and hit enter:

?application.startuppath

For me (xl2003 and winXP):
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

PT wrote:
gt;
gt; I copied Book.xlt and personal.xls to the XLStart folder. No change - still
gt; getting the default opening
gt;
gt; *************************************************
gt; quot;Bob Phillipsquot; gt; wrote in message
gt; ...
gt; gt; Move the file Book.xlt in the Excel start directory (where Personal.xls is
gt; gt; as well).
gt; gt;
gt; gt;
gt; gt; quot;PTquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; I've long used a customized Personal.XLS worksheet which contains a
gt; gt;gt; number
gt; gt;gt; of personalized macros, buttons, toolbars, etc..
gt; gt;gt;
gt; gt;gt; I installed Office 2003 on my replacement computer. I assumed I'd simply
gt; gt;gt; copy the Personal.XLS file from its position in
gt; gt;gt; C:\Docs amp; Settings\Username\App Data\Microsoft\Excel\XLStart over to the
gt; gt;gt; corresponding position on the new computer.
gt; gt;gt;
gt; gt;gt; But I still end up with the canned opening worksheet as before the
gt; gt;gt; change.
gt; gt;gt; What else should I be doing?

--

Dave Peterson

arrow
arrow
    全站熱搜

    software 發表在 痞客邦 留言(0) 人氣()