sverker123
New Member
- Joined
- Aug 1, 2017
- Messages
- 1
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!
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!
