Results 1 to 4 of 4
  1. #1
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Loads .xls

    I have a short cut to Excel with quick keys Ctrl + Alt + S
    when it loads I have it load a special file 2001.xls but befor it loads this file it loads a file called Personal.xls I removed the shortcut to this file, but it still creates it every time I load the program, how can I get rid of this file ?
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Loads .xls

    Hi,

    This is what <A HREF="http://msdn.microsoft.com/training/free/chapters/m1301/Topics/odev00098.htm" target="_blank">Microsoft say about personal.xls:

    "Excel provides a Personal Macro workbook named Personal.xls, which it stores in the Excel Startup folder. Each time that you start Excel, Personal.xls opens as a hidden workbook. When you record a macro, you can choose to store that macro in Personal.xls.

    The Personal Macro workbook is always open. If you want a procedure to be available to every workbook, store the procedure in the Personal Macro workbook."


    So it has a use- but if you don't want it, take it out of your Excel startup folder- which would typically be in an XLSTART folder under Microsoft Office, Office.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Loads .xls

    Thanks for taking the time, I found the folder under
    WindowsApplication DataMicrosoftExcelxlstart
    I will make a temp storager folder and move the file.
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Loads .xls

    Just as a footnote to this, if you record a macro and choose to save it in your personal macro workbook, Excel will recreate Personal.xls if it doesn't exist.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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