Is it necessary to create the macro through automation, or would you be able to create the macro in advance, and simply run it through automation at run-time? I have used this technique and found it to be a much quicker way of formatting your excel sheets than writing the format directly from foxPro