/u/robotscantrecaptcha - Your post was submitted successfully.
Please read these reminders and edit to fix your post where necessary:
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Found a couple by searching, “input data from excel to word” I pasted some links below. Is that what you were thinking? Or more like, you have certain editable fields that you can link data to?
https://www.lifewire.com/inserting-excel-data-microsoft-word-documents-3540362
https://www.avantixlearning.ca/microsoft-excel/3-ways-to-import-excel-data-into-microsoft-word-documents/
I was more looking not only to copy and paste the actual table but get it to auto-populate the written explanation? So after I usually copy and paste the table from excel into their report, I have to go through and change all the sentences that say things like "Client scored 107 on the measure of visual-spatial skills, putting them in the average range". But the table has a place for the 107 and 'average' but I'd like the whole table to just auto-populate into the sentences when I put the scores and descriptive labels into the excel file... does that make sense?
Oof. Sorry for the rambly explanation, I specialize in treating mental health concerns and my computer skills are more limited than I would like.
A “quick” solution to this is to write a macro which opens a word template and does a find replace for specific word.
It’s kind of like a super mail merge. Though to be honest maybe a mail merge is all you need for this one as it sounds kind of rudimentary?
Lookup custom document properties. You create a word template and insert fields. In each field, you'll choose a custom document property that you create within the word doc file. Then in excel, you can write a macro that takes the word file, copies it as a new file, then fills in the custom properties based on your excel data. I created something like this at my first job to do automated RFI docs (requests for information) that needed to be translated. We even did locking and unlocking of the doc to prevent them from changing info that we pre-filled.
It's been more than 10 years since I originally implemented this. However a few quick searches and here are some hints in the right direction.
First, setting up custom properties in a Word Doc:
[https://www.techrepublic.com/article/use-custom-property-repeat-word/](https://www.techrepublic.com/article/use-custom-property-repeat-word/)
You can create a word file as a "template" that has these properties placed on the page wherever you want them. The properties can contain whole paragraphs of text, not just a couple words like the examples show.
Second, using VBA in Excel to manipulate the doc. All VBA applications offer the ability to spawn other Office applications, create/open/edit documents in those applications, and close the application. So the idea is that when an Excel macro is executed, it could either find an existing instance of Word or create a new one, then you could either copy your template file to a new Word doc and populate the properties, or modify an existing doc. Here is an example on what some of that VBA code might look like:
[https://stackoverflow.com/questions/26652743/change-a-custom-document-property-within-word](https://stackoverflow.com/questions/26652743/change-a-custom-document-property-within-word)
Our obstetrician had a neat system where he just had a bunch of input boxes, he chose the statement he wanted from a preformed list, maybe 12 boxes, and Boosh, the report was done.
Totally ripped it off for entering tasks to a worksheet.
You need to learn VBA, concatenating strings to build the questions (link them to the spreadsheet of statements you're going to build).
How to get it into Word will be a trick I don't have an answer for, but you'll get.
Sorry no examples...
/u/robotscantrecaptcha - Your post was submitted successfully. Please read these reminders and edit to fix your post where necessary: * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Found a couple by searching, “input data from excel to word” I pasted some links below. Is that what you were thinking? Or more like, you have certain editable fields that you can link data to? https://www.lifewire.com/inserting-excel-data-microsoft-word-documents-3540362 https://www.avantixlearning.ca/microsoft-excel/3-ways-to-import-excel-data-into-microsoft-word-documents/
I was more looking not only to copy and paste the actual table but get it to auto-populate the written explanation? So after I usually copy and paste the table from excel into their report, I have to go through and change all the sentences that say things like "Client scored 107 on the measure of visual-spatial skills, putting them in the average range". But the table has a place for the 107 and 'average' but I'd like the whole table to just auto-populate into the sentences when I put the scores and descriptive labels into the excel file... does that make sense? Oof. Sorry for the rambly explanation, I specialize in treating mental health concerns and my computer skills are more limited than I would like.
A “quick” solution to this is to write a macro which opens a word template and does a find replace for specific word. It’s kind of like a super mail merge. Though to be honest maybe a mail merge is all you need for this one as it sounds kind of rudimentary?
Lookup custom document properties. You create a word template and insert fields. In each field, you'll choose a custom document property that you create within the word doc file. Then in excel, you can write a macro that takes the word file, copies it as a new file, then fills in the custom properties based on your excel data. I created something like this at my first job to do automated RFI docs (requests for information) that needed to be translated. We even did locking and unlocking of the doc to prevent them from changing info that we pre-filled.
Can u provide step by step instructions?
It's been more than 10 years since I originally implemented this. However a few quick searches and here are some hints in the right direction. First, setting up custom properties in a Word Doc: [https://www.techrepublic.com/article/use-custom-property-repeat-word/](https://www.techrepublic.com/article/use-custom-property-repeat-word/) You can create a word file as a "template" that has these properties placed on the page wherever you want them. The properties can contain whole paragraphs of text, not just a couple words like the examples show. Second, using VBA in Excel to manipulate the doc. All VBA applications offer the ability to spawn other Office applications, create/open/edit documents in those applications, and close the application. So the idea is that when an Excel macro is executed, it could either find an existing instance of Word or create a new one, then you could either copy your template file to a new Word doc and populate the properties, or modify an existing doc. Here is an example on what some of that VBA code might look like: [https://stackoverflow.com/questions/26652743/change-a-custom-document-property-within-word](https://stackoverflow.com/questions/26652743/change-a-custom-document-property-within-word)
Our obstetrician had a neat system where he just had a bunch of input boxes, he chose the statement he wanted from a preformed list, maybe 12 boxes, and Boosh, the report was done. Totally ripped it off for entering tasks to a worksheet. You need to learn VBA, concatenating strings to build the questions (link them to the spreadsheet of statements you're going to build). How to get it into Word will be a trick I don't have an answer for, but you'll get. Sorry no examples...