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 & 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)
"PT" <xyz@xyz.com> wrote in message
news:#a8oY80MGHA.3944@tk2msftngp13.phx.gbl...
> 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 & 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
>
>
I copied Book.xlt and personal.xls to the XLStart folder. No change - still
getting the default opening
*************************************************
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23ppxT%230MGHA.3392@TK2MSFTNGP14.phx.gbl...
> Move the file Book.xlt in the Excel start directory (where Personal.xls is
> as well).
>
>
> "PT" <xyz@xyz.com> wrote in message
> news:#a8oY80MGHA.3944@tk2msftngp13.phx.gbl...
>> 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 & 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?
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:
>
> I copied Book.xlt and personal.xls to the XLStart folder. No change - still
> getting the default opening
>
> *************************************************
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:%23ppxT%230MGHA.3392@TK2MSFTNGP14.phx.gbl...
> > Move the file Book.xlt in the Excel start directory (where Personal.xls is
> > as well).
> >
> >
> > "PT" <xyz@xyz.com> wrote in message
> > news:#a8oY80MGHA.3944@tk2msftngp13.phx.gbl...
> >> 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 & 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?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks