Greetings everyone. I hope the end of the school year is treating you well.
I have a question that I'm hoping someone can assist me. In an effort to
minimize cheating/copying off of one another, I've been giving assignments
that differ from some of their other classmates. The problem has been
taking the time to write each one up and the answers.
Recently, I found a way to link Excel to Word. I'm able to make numerical
changes in Excel, have it automatically do the calculations and put the
numbers and answers in Word document/template. The problem I've discovered
was that depending on the size of the cell in Excel, the cell also shows up
in Word so that the spacing around the values makes it difficult to read.
What I'm doing is similar to what is done with Access (like creating an
address book) and then importing it into a Word document (mail merge or
merging it into a form letter). Access is able to input the words and
numbers, without messing up the space around the imported values.
I'm wondering if I have to take a longer route to do what I want to do. Put
the values in Excel and have it do the calculations. Have the information
transferred to Access. Then from Access have it merged into Word.
If I do have to take the long route, does anyone know how to do it? Is
there a way I can go directly from Excel to Word without messing up the
space? Any input would be appreciated.