PDA

View Full Version : Can't find the personal macro workbook



wpanssi
11-06-2008, 04:25 AM
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!

Bob Phillips
11-06-2008, 06:34 AM
Try going into the VBIDE (Alt-F11), and in the immediate window use

?application.StartupPath

and look in that directory.

wpanssi
11-07-2008, 06:30 AM
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.

Bob Phillips
11-07-2008, 07:27 AM
Then you need to create one.

wpanssi
11-10-2008, 12:31 AM
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!