Hi everyone,
I'm trying to export worksheet cell contents into word as text (not as a table) and format the text at the same time. I found some VBA scripts to export to word, however, these seem to rather copy/paste the whole table structure into word, which is not what I'm trying to do :-(
I've tried to summarise what I would like the script to do in the attached + I added a screenshot of how the word document should look like.
Note that I don't want to create a word template that Excel then populates on click of a button, the script should rather open word, open a blank template, copy the cell content over as text (with formatting as described in the file) and add line and page breaks at the same time.
Still a VBA newbie so a bit lost where to start really. Hope you can help?
Many thanks!
Bookmarks