Exporting data to MS Word + Formatting??

Dear all,

I am trying to manipulate some data in Excel and to then export the final result into Word into a nice report.

So far, I have managed to do the query I need to do, place the results into an array and then when I click a button it dumps it into to Word.

What I would like to know is how can I add the formatting, such as dividing lines, headings etc to make it into a better looking report rather then lines of text?

Much appreciated!

re: Exporting data to MS Word + Formatting??

One quick and easy way to get the code for this kind of thing is to do it manually, after telling Word to record a new macro. Then stop recording, edit the macro, and the code is all laid out for you, to copy and modify.