My question is where are all my macros located? I found the WTF files and I am hoping that is all I need.
The macros are all contained in the macro-cache files at both account level and character level. They all live in the WTF directory structure.

I'm guessing you know all about Virus scanners, etc, so won't go there