Thread: Personal.xls
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Personal.xls

Doug

Win98SE and WinXP store the XLSTART folder in different places, post
Excel97, I believe. It sounds like you have two Personal.xls files on your
hard drive. Here's a scenario where that could happen: You install Excel
on your WinXP and record a macro to Personal.xls. This creates a
Personal.xls in Application Data\Microsoft\...\XLStart\. You move your old
Personal.xls to your new laptop in its current location, likely \Program
Files\Microsoft Office\Office\XLStart\ and now you have two files with the
same name. The newer Personal.xls is opened when Excel starts, but all your
shortcuts, buttons, etc. point to the old file. It tries to open the old
file and you get a name conflict.

Search your hard drive for Personal.xls and you'll probably get two hits.
Rename one of them and open them both in Excel. Consolidate all of the
macros in both into the one still name Personal.xls and save it to the
Application Data path. Delete the other one. Now all your buttons will be
totally screwed up because the file they point to won't exist. You'll have
to reassign the macros to them. You could avoid that by deleting the newer
file and consolidating into the older one, but for a little work to reassign
them, I think you'll be better off having the file in the right place.

On the other hand, I could be way off and that's not the problem at all.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Doug Boufford wrote:
Frank Kabel wrote:


Hi
try:
http://www.contextures.com/xlfaqApp.html#AlreadyOpen

-- Regards Frank Kabel Frankfurt, Germany "Doug Boufford"
schrieb im Newsbeitrag
...
I re-installed Office 2000 onto a new laptop running WIN XP Pro
from an older one running WIN 98SE.

All of my macros are stored in Personal.xls, and ran perfectly on
old laptop. Now when I try to run a macro, I receive the message
that a file named Personal.xls is already open and you cannot open
2 files with the same name. (This I know!)Personal.xls always
loaded but was hidden. I can't figure out what I have forgotten to
change in the new
setup to let the macros run.
Any hints would be appreciated...

TIA
Doug


Frank
Thanks for the link, but neither trick fixed the problem

Doug