Automatically Open a File
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Automatically Open a File

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Toronto, Canada
    Posts
    252
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a file entitled "Macro Library" which does not reside in the same subdirectory as many of the files I use. I would like the "Macro Library" file to open automatically whenever I access Excel. Is this possible?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    let me quote smozgur's reply just recently to another question...

    "There is a file called as Personal.xls. It is personal workbook and it opened everytime you open a workbook, and it is hidden as default. You can store your macros in it so you dont need to copy macros in all workbooks that you want to use in. To create a personal.xls if you have not already just Tools_Macro_RecordNewMacro and select Personal Macro Workbook for "store macro in" choice. After recording a simple macro by this way you can goto to VBE and see the Personal.xls file. Just move your macros there. "

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    BTW to add
    Per... xls is really ggod and easy to use, but if on network underarmagedon that is IT Dept rebuild, this will be removed as non standard excel setup/////

    then like me you will not be able to use it ... sadky... just in case, i have stumbled on this before.... hope not he case
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    There is another way. Say you want the original file on a LAN drive, you can create a shortcut (right click on file, select "create shortcut") of the file and place the shortcut in your "xlstart" directory. This folder ought to be on your c: drive, do a search for it.

    Should fire up every time you fire up XL. Hope this helps.

    _________________
    Cheers, NateO

    [ This Message was edited by: nateo on 2002-04-03 20:50 ]

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