Angels have the Phone Box
I can't say, because I am not a VB user, but you would think that macros created in Excel files, are saved with the files. Every Excel file I've made with a macro, has always remained intact when I moved it. I'm afraid I can't help you with that one. Hopefully someone else will pop in and have an answer for you.
I don't know how to extract a key from a pulled hard drive. I only have ever run Belarc Advisor on a working system, to grab keys and save them. Again, sorry, but I'm not of much help there either.