Lost Macros. Can't build new ones!

[Robertislearning]

Team,

For some reason I have lost all of the macros that I built and saved in my Personal Workbook. When I try to go back and rebuild a macro, I get the following message:

"Personal Macro Workbook in the Startup folder must stay open for recording."

Has anyone seen anything like this? Is there a way to recover the lost macros?

Thank you in advance for your help!

Robert.

 

[Dreamboat]

Sounds like your personal.xls file has been deleted or moved. Can you find it?

If so, put it back into the folder called XLSTART.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[Robertislearning]

Anne,

Thank you so much for your prompt response to my post. I did a search for personal.xls and sure enough it was not found. I take it that this file is where all macros are stored.

My question now is do I just place an empty notepad document in there and name it personal.xls? Also, where is "there"? What directory would I store this file in?

Microsoft office -> Office10 -> XLStart?
or
Microsoft Office -> Office10 -> Startup?

Thanks again!!!

Rob.

 

[Dreamboat]

Don't do that, Robert.

Just go to record a macro--any macro.
You're asked where to save it, so choose personal macro storage (or whatever it's called). That'll automatically create a personal.xls file. Once you've got your macros back, you may want to save a copy of your personal.xls somewhere else as a backup!

The personal.xls will become created in XLSTART, and if you open it directly, the worksheets are hidden, but the code is stored. To see the code, just record that macro, and hit Alt+F11. On the left, you should see Book1 and also Personal. Double-click Personal and have a look in a module called "New Macros" or similar...You'll see your codes in there.

If you use so many macros, you should start editing them. When you record macros, there's often a lot of nonsense code created that can really be deleted to shorten the code and to save space in a personal.xls file.

See

http://www.theofficeexperts.com/officevba.htm

Also, if you can't figure out what's needed in a macro you've recorded, you can paste the recorded code here. We'll help you trim it down and you can learn from that what to look for.

Hope it helps!



Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[Robertislearning]

Anne,

Thanks again for such a quick response! When I try to record a new macro, I get the following message: "Personal Macro Workbook in the Startup folder must stay open for recording."

One interesting thing is that I CAN create a macro for an individual Workbook. Unfortunately, I need to have this opened into the "Personal Macro Workbook" so that I can use it with multiple workbooks.

Tks for the tip on saving macros....After this experience, I definitely will!

Robert

 

[Dreamboat]

Try searching for personal.xls on your hard drive again.

Only this time, first open MyComputer, and hit Tools-Folder options. Make the settings so NO files are hidden, and do your search for personal.xls again.

If you don't find it, then try running the Excel troubleshooting at

http://www.theofficeexperts.com/excel.htm

and try recording again.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[bluedragon2]

Might also want to check in your recycle bin for it.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[Robertislearning]

Anne,

Success!!!!!

I went in to My Computer and set it to show hidden files but unfortunately it still did not find the personal.xls file. Then I decided to go back and do one final search and found the 'Advanced' search button. In there I also checked 'find hidden files' and wham! It found it. I copied that personal.xls file from the directory it was in to the xlstart folder and now I've got all of my macros!!!!

Thank you so very much. I sincerely appreciate your skill & responseiveness!

Robert.


Bluedragon...tks for your tip!

 

[Dreamboat]

No problem, Robert! I'm so glad you found 'em!


Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books