Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Can't find my PERSONAL.XLS workbook

This is a discussion on Can't find my PERSONAL.XLS workbook within the Excel Questions forums, part of the Question Forums category; I just finished loading Excel onto my new computer, running Windows XP, and can't find my PERSONAL.XLS macro folder. The ...

  1. #1
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Can't find my PERSONAL.XLS workbook

    I just finished loading Excel onto my new computer, running Windows XP, and can't find my PERSONAL.XLS macro folder. The new Windows directory doesn't have a sub-folder called "Applications Data", and a search on PERSONAL.XLS in Windows Explorer turned up zilch.

    Does anyone know where the XLStartup folder is on Windows XP?
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  2. #2
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default Re: Can't find my PERSONAL.XLS workbook

    Barry, try:

    C:\Documents and Settings\Your Name\Application Data\Microsoft\Excel\XLSTART

    Or, just Unhide the Personal macro workbook and do a save as and you can get the path that way.
    Todd


    "I'm a Data Anlyst(intermediate) and have no idea what it's all about."

  3. #3
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: Can't find my PERSONAL.XLS workbook

    Hi, T-Bone. Got as far as sub-folder BARRY, but no Application Data below that.\

    Plus, stupid me, it's been so long I don't remember how to unhide a workbook.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  4. #4
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default Re: Can't find my PERSONAL.XLS workbook

    Strange.

    Unhide Workbooks: Go to Window|Unhide|choose Personal from the list.
    Todd


    "I'm a Data Anlyst(intermediate) and have no idea what it's all about."

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: Can't find my PERSONAL.XLS workbook

    OK, went to good old Help and found how to unhide the workbook, which I did, but there's no file path shown. I recorded a simple macro to the PERSONAL workbook, and ran it, so I know it's there, but a search of my C: drive still doesn't find it.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  6. #6

    Join Date
    Nov 2002
    Posts
    981

    Default Re: Can't find my PERSONAL.XLS workbook

    Click on Start and then Search.

  7. #7
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default Re: Can't find my PERSONAL.XLS workbook

    You know, I did a search on my drive, and it came up empty-handed also. I uhnhid my Personal workbook and looked at where it was saving to, and then I went to that directory (which is what I posted above) and there was nothing there. So, I unhid all hidden files on my computer, and there was still nothing there.

    This Personal workbook must be a veryhidden file or something because it would appear it doesn't exist even though it does.

    Maybe someone can shed more light on the situation...

    Quote Originally Posted by Barry Katcher
    Hi, T-Bone. Got as far as sub-folder BARRY, but no Application Data below that..
    Barry, I forgot to mention that the Application Data file is a hidden folder. To see hidden files in WindowsXP go to Tools|Folder Options|View|Show Hidden Files and Folders
    Todd


    "I'm a Data Anlyst(intermediate) and have no idea what it's all about."

  8. #8
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: Can't find my PERSONAL.XLS workbook

    Yes, I just put a macro in PERSONAL to display the full path and name in the title bar and, sure enough, it's in the path T-Bone gave me, but I, too, cannot find Application Data in my C:\Documents and Settings\Barry folder.

    I'm trying to copy/paste my old PERSONAL workbook with 2 years worth of macros into the new XLStart folder, but the **** system won't let me navigate to it!

    GRRRRRRRRRRR. Gimme back my old Commodore 64.

    Anyone else have any suggestions?
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  9. #9
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default Re: Can't find my PERSONAL.XLS workbook

    Quote Originally Posted by tbardoni
    Barry, I forgot to mention that the Application Data file is a hidden folder. To see hidden files in WindowsXP go to Tools|Folder Options|View|Show Hidden Files and Folders
    Update: Actually, I found mine. My problem was that I didn't have an existing Personal until I recorded a macro to it.
    Todd


    "I'm a Data Anlyst(intermediate) and have no idea what it's all about."

  10. #10
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: Can't find my PERSONAL.XLS workbook

    Bones, just saw your last msg:

    Barry, I forgot to mention that the Application Data file is a hidden folder. To see hidden files in WindowsXP go to Tools|Folder Options|View|Show Hidden Files and Folders
    How do I get to Tool in WindowsXP? It's less than an hour, and I hate XP already!

    EDIT: Never mind, got there in Windows Explorer, unhid the folder, should be a snap now. Thanks, T-Bone.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com