Results 1 to 7 of 7
  1. #1
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Question Excel 2010 - startup macro problems

    I work for the VA, and I.T. likes doing thing their way. Which means, half the time I don't understand it. Anyway, I am having trouble with files in the C:\Users\VHACTXWhittJ\AppData\Roaming\Microsoft\Ex cel\XLSTART folder. They don't always open when I start Excel 2010. I have a Book.xltx, which does open on startup at times, and a Personal.xlsm that never seems to open. When I go to my list of macros, there are none in the list. (They are not add-ins. I haven't tried to fool with trying to make them add-ins.) It seems that Excel will open macro files on my personal network drive. I have the full complement of macros on the list after I open that Personal.xlsm file. Should I clear out the XLSTART folder and use the macro file on my network drive?

    I may have asked this before, but I can't find the thread if it's here. Please excuse any duplication. Have a nice, air-conditioned day.

    Jim Whitt
    Pharmacist
    Temple, TX
    Last edited by RetiredGeek; 2015-07-30 at 11:52. Reason: Added NoParse tags

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jim,

    Have you checked your Trust Center settings to make sure that network directory is in your Trusted Locations list? It will warn against network locations but you can set them as trusted. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Boy, I'll be glad when I can be a Retired Geek. Only 6 more years to go.

    I'm trying to upload a jpg of the Trusted Locations screen. There seems to be a lot of Trusted Locations. (If the personal network drive were available, you'd see a "Z:\"). Thanks for the help, boss.
    Attached Images Attached Images

  4. #4
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Happy Monday. Just wanted to check if you can see the screen shot, or if there's anything else I need to do to improve startup. Thank you!

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jim,

    Yes you successfully uploaded the screen shot.

    Do you have any specific questions about things that might be slowing down your startup?

    Of course the obvious thing is not to have the startup routine on the network.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts
    The thing that concerned me is the sheer number of folders Excel has to look at. Will adding or deleting folders make any difference? Thanks.

  7. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jim,

    You should only have one folder as your User Startup Folder you don't add a location but rather modify the existing one to point to the network. That will be the only location in which it will search for your Personal.xlsm or .xlsb file. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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