Macro to create a Word Document or pdf



I have an Excel file with several different sheets, and I want to create a Word Document or a pdf, with some information that is spread on the different excel sheets. Is this possible?

Does anyone know where I can learn to do this?




One would use a Word template containing the entire text, with place markers (perhaps Fields or Bookmarks) where fragments from Excel should be inserted. You might want to look into MailMerge. For your question here to bear fruit a copy of your workbook as well as the Word template would be required and much more detail of what result you finally want. Since this site doesn't support uploading of either Word documents or pictures thereof you may find it difficult to phrase a question that can be answered here.
Variatus (rep: 4382) Apr 7, '20 at 9:30 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login