Automatically open a file whenever Excel opens

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Automatically open a file whenever Excel opens

  1. #1
    Board Regular
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Automatically open a file whenever Excel opens

     
    Is there a way to make a file automatically open whenever you open Excel? Preferably in the background similar to the way personal.xls opens when Excel opens.
    Smooth seas do not make skilled sailors.

  2. #2
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatically open a file whenever Excel opens

    Yes. Save the file in the XL Startup Directory, normally located in a path similar to this one...

    C:\ProgramFiles\MSOffice\Office97\Excel\XLStart

    This will load the file each time XL opens. Now to get it to be hidden there are a few different ways. One, you could use a Workbook_Open code to hide the workbook as it opens. Two, hide the workbook (goto Window|Hide), then open the VBE (ALT+F11), and find the workbook in the project list. Now goto File|Save and this workbook will now be saved hidden. Therefor everytime it is opened it will not be shown as active.

  3. #3
    New Member
    Join Date
    Nov 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatically open a file whenever Excel opens

    You're going to laugh since your post is 9 years old, but I used your solution today. Thank you!

  4. #4
    New Member
    Join Date
    Dec 2011
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatically open a file whenever Excel opens

    I am using this solution today! Thank you!

  5. #5
    New Member
    Join Date
    Dec 2011
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatically open a file whenever Excel opens

      
    Quote Originally Posted by TommyGun View Post
    Yes. Save the file in the XL Startup Directory, normally located in a path similar to this one...

    C:\ProgramFiles\MSOffice\Office97\Excel\XLStart

    This will load the file each time XL opens. Now to get it to be hidden there are a few different ways. One, you could use a Workbook_Open code to hide the workbook as it opens. Two, hide the workbook (goto Window|Hide), then open the VBE (ALT+F11), and find the workbook in the project list. Now goto File|Save and this workbook will now be saved hidden. Therefor everytime it is opened it will not be shown as active.

    What if the file I would like opened automatically is saved out on a networked drive and has to stay at that location? Can I put a shortcut in that file and have it work the same way?

User Tag List

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