>Part of the prob was I was unsure about what I wanted the data outputted to look like, I just knew I didn't like the "flat file" look
OK. So what you do is a mockup of some sample data in Excel itself. Start the macro recorder and type away, format cells, widths, colors, whatever you want it to look like. Then open the created file using the VBA editor (ALT-F11). VBA is very easy to read and translate to VFP automation code.
If you get stuck in translating any particular piece of VBA to VFP, post it here and we'll fix it for you fast and easy.