View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Problem with Personal.xls

Your Personal.xls is not located in the folder that Excel looks in when it
opens. Do this: You say that you can search for and find Personal.xls.
That means that you also know the path to it. Find it and rename it.
Choose any name you want.
Open Excel. Click on Tools - Macro - Record new macro. Choose to put
this new macro in the personal workbook. Click OK. Stop the recorder. You
just created a Personal.xls file in the proper folder..
Search for Personal.xls. When you find it you will also find the path
to it. Put your original Personal.xls file into this folder. Delete the
Personal.xls file you just created and rename your original Personal.xls
file. Done. HTH Otto
"Toxicdistortion" wrote in message
...

"Bernard Liengme" wrote in message
...


"Toxicdistortion" wrote in message
...
Windows XP Pro SP2
Excel 2002 SP3


For some reason Personal.xls isn't opening with Excel. The file exists,
and it's located he

C:\Documents and Settings\My User Account\Application
Data\Microsoft\Excel

Any ideas why or why not?

-gk-



The PERSONAL file is generally hidden. Have you tried Window|Unhide?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


Yes, I checked to see if it was hidden (as it should be) and it simply
wasn't there. As I indicated in my original post, the file exists as I
searched for it and found it. But for some reason it is not opening with
Excel. The main tip off was that none of my custom menus were loaded when
Excel started, and also it doesn't show up in the VBE.

-gk-