How do I change the XLStart folder
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How do I change the XLStart folder

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    I cannot save Macros in the PERSONAL Workbook, because Office is on a server, the folder XLStart also and I don't have the necessary permission to create this workbook on this server/folder.

    This path is given by Application.StartupPath, but this method is Read-Only and I don't find on the Registry the appropriate key.

    So how can I save the PERSONAL.XLS ???

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Create your own personal.xls and save it on your local c: drive in a folder. Then under options, on the general tab, point to this folder in the Alternate Startup Location

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