Hi all
I have excel file: main.xlsm with data in sheets("data")
Now I want macro VBA to do that
- Create new Word file with name Report.docx
- Copy sheets("data").range(A1:C6) paste to report.docx as table, then copy sheets("data").range(A9:A13) paste belove as text
- Copy sheets("data").range(H1:J6) paste belove as table, then copy sheets("data").range(H9:H13) paste belove as text.
- Save Report.docx the same folder with main.xlsx.
I attach excel file like source and word file like result that I want
Please help me to do that, many thanks./.
Bookmarks