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 formatting only 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, many thanks!
Bookmarks