Consulting

Results 1 to 5 of 5

Thread: Can't find the personal macro workbook

  1. #1
    VBAX Regular
    Joined
    Oct 2008
    Posts
    31
    Location

    Can't find the personal macro workbook

    I'm using vista and excel 2007. I created a macro and saved it to my personal macro workbook. But when I go see folder C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XLSTART
    I find out it's empty. I have enabled view hidden files and folders.

    Why I can't see my personal macro workbook?

    And related question:
    How can I make my macros automatically available to other users as well?

    Thanks in advance!

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try going into the VBIDE (Alt-F11), and in the immediate window use

    ?application.StartupPath

    and look in that directory.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Oct 2008
    Posts
    31
    Location
    Quote Originally Posted by xld
    Try going into the VBIDE (Alt-F11), and in the immediate window use

    ?application.StartupPath

    and look in that directory.
    It shows me the same folder. But when I open it the folder is empty.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Then you need to create one.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Oct 2008
    Posts
    31
    Location
    Ok. I seems that the macro created in personal workbook was not saved until I exit excel. After quitting I can now see the macro workbook in the folder. Thanks for help guys!

Posting Permissions

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