There is a good example that ships with LV 7.1 called Run Macro On Word Table.vi. You just need to use the excel vi's under the Report Generation Toolkit. If you don't have 7.1 and have at least version 6.1, you need Excel Import Module, Excel Run Macro, and Excel Remove Module vi. The easiest way to generate you macro code for the Excel Import Module is to open excel and record the macro. Then go and edit the macro in excel, copy the the code to the clipboard, and paste the code in a text box in LV and connect it to the module code pin. See the attached screenshot for further explantion.
