Hi All,
I have a word document that I use as a template to produce results reports.
I have a line of text e.g.
The results found a difference of XXXX%
This is the same for alot of sentences and details.
What I want to do is have a box pop up when I open the Word document, allow me to select an Excel spreadsheet from my desktop, and fill in the XXXX sections based on certain cell values.
The cells used for each thing will be the same from each spreadsheet even though the values will change based on the results found.
Can anyone help with this please
Thanks
dvent
Can no1 provide a solution to this?
dvent
Not sure about switching workbooks but lets say your value is always in a certain cell in a certain workbook (e.g. C12).
Open up your Word Doc and the Spreadsheet and then Copy C12.
Go to your Word Doc and Paste Special > Unformatted Text and make sure Paste Link is checked. Does that help?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks