Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Directory of Personal.xls (xl97, Win2000)

    I have an annoying Excel problem and this is always the best place to find explanations.

    I have various macros in my personal.xls and I've assigned some to toolbar buttons. When I open Excel by clicking on an excel.exe shortcut, my toolbar works fine. However when I open excel by clicking on an xls file, the toolbar macros don't work. Excel tells me that I can't open personal.xls because a file with that name is already open, blah, blah. I think I've traced the source of the problem and I'm wondering if anyone else has seen this.

    If I open excel via excel.exe and I unhide my personal.xls and look at its Properties, I see that the location is:
    C:Program FilesMicrosoft OfficeOfficeXLSTART

    When I open excel via an xls file and look at the personal.xls Properties, I see that the location is abbreviated to the old 8 character DOS path:
    C:Progra~1Micros~2OfficeXLSTART

    My toolbars seem to be looking for the full path name, not the 8 character abbreviated path. This problem has only popped up in the last month. Before that, I never noticed any problems. I've always used both methods for opening Excel. Any suggestions?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Directory of Personal.xls (xl97, Win2000)

    If you go to windows explorerer and look at your association for XLS files to open (tools - folder options - file types (tab) - find excel - select <advanced> and then look at the open, how is the program listed?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Directory of Personal.xls (xl97, Win2000)

    It had the abbreviated 8 character path name. I changed it to the full path name and my problem looks solved.

    Steve, you're da man!

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Directory of Personal.xls (xl97, Win2000)

    Glad I could help.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •