Using a word macro to format excelsheet

[Ashish_FC]

Hello all,

I'm trying to generate a automated word report document wherein I'll insert
multiple diagrams and also tables from excel sheet. The problem though is
that before I insert an excel sheet as on object or file into word I need to
format it a little by adding a few rows and columns and adding a labels in
those new cells. I'm having serious problems doing this and I'm running out
of ideas. The word report needs to be fully automated and thus i can't write
a dedicated excel macro and then insert it using a word macro. Pls let me
know your valuable suggestions.
Thanks,
Ashish.

 

[Ed]

Hi, Ashish. You can set object references to Excel in Word VBA and
manipulate a workbook file. See
http://word.mvps.org/faqs/interdev/ControlXLFromWord.htm to get you started.
Don't forget to set a reference to Excel.

For any more specific information, you might need to explain a bit more
about what you're doing to the Excel file: is it a set number of rows or
columns to add every time? same labels? adding in any data or making any
calculations?

Ed