![]() Excel will populate all fields in the new copy and leave it open for you to edit and save.Excel will shortly open the template word document and make a copy of it. ![]() You might also want to rename the Button to something more meaningful such as Export to Word (right click on button and Edit Text).ĩ.) Press the button you created under step 4 and observe: Rearrange these fields in your template to suit your needs, then close/save the template file (it automatically saves back into the Excel file).Ĩ.) Assign the ExportExcel2Word macro to the button you created under step 4. This will open the word file you added in step 2 and will put all named fields at the bottom of the document using DocProperty fields. Hint: Only individual cells have been tested.ĭeveloper -> Macros -> Select. DOCUMENT PROPERTIES WORD STATUS CODE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |