Exporting from Excel to Word

[sverker123]

Hi there,

I'm new to VBA and I have find myself stuck with trying to export data from Excel to Word using VBA.

Basically, what I need is a piece of code that opens Word, copies a dynamic range in my sheet (which I have defined):

.Range("A12:J" & Range("A65536").End(xlUp).Row)

Then, the copied section would then be pasted into the Word document, and lastly the word-document would be saved and the name of the file would be Report_X - with X being the value of cell H12.

Also, the only formatting that seems to work is if the content is pasted into a word-document that is in A3. Is that possible to do?

I would really really appreciate some help as I can't seem to find anything about how this could be done.

Many thanks!