M.i.a. Macros!!!

[aguestnga]

K, I'm new to this so play nice.

I've inherited a mess. I've got like 30 workbooks coming to me to format then upload into an Access Database. I have to do stuff like delete the first sheet since it's just an instruction sheet, unmerge rows, insert columns, copy values from cells to the new columns, then delete the top five rows...basically cleaning up so Access won't spit the worksheet back at me when I try and import!! Being the lazy person I am, I don't desire to do the same steps 30 different times. So I'm thinkin...MACRO!!! So I'm proud of myself...I make myself a sample workbook, record a new macro in the PERSONAL folder (because these workbooks will all have different names but same layout) to use on them all. I'm feeling all smug until I come in the next day and try to open my macro to run it again on a trial and IT'S GONE...POOF...VAMOOSE!!! I do this crap time and time again and ain't enough alcohol to kill my pain or make me smarter. What is up with naming these blasted things and where did they go??? OH, but to add insult to injury, the PERSONAL workbook that my invisible macro is stored in opens every single time I open ANY workbook.

This is maddening. Can anyone shed light on this problem? Again, this was my first attempt at a macro so, I'm begging, be nice.

[davesexcel]

Maybe this sit could help

http://support.microsoft.com/kb/211563/EN-US/