more-arw search

Q&A Forum

Import Capabilities for Word

We currently use Excel for much of our periodic reporting, including a number of supplemental schedules. We are developing a management report ( a narrative md&a) and I was wondering how easy it would be to link this document so that it pulled/merged numbers for our excel workbooks, as opposed to having to re-key data>

Answers

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

As long as the Excel and Word files are always in the same location, you can link them up fairly easily. If you need to send out the report, print it to PDF and send it out that way.

In Word, go to the Insert tab and insert an Excel table. From inside a cell in that table, you can access your other workbooks and select the appropriate tab and cell.

Let me know if you have any follow-up questions.

(Agent, JKS Solutions, Inc.) |

You need to investigate how to use the excel/word functionality related to "mail merge". Mail merge with Excel can be used in creative ways to get data into Word. Once the data is in Word, you need to investigate online for a tutorial that will show you how to format the numbers that pop in from the mail merge.

Word was designed as a printing tool, not a word processor, sounds weird, but that is why it is absolutely no good at formatting. But is great at printing structured reports.

When you define the fields of the template in Word, you will have to add some coding to each field by opening the field and formatting the numbers and dates as you would like them to appear. This can be frustrating but you can easily find a tutorial online. I don't remember the one I'm referring to. But I have to look it up every time.

Try googling: Word form field mail merge format code

It's not really VBA, it's more like setting custom formats from the format dialog box on a right click.

Good luck.

Ken Stumder
Title: Finance Director / Controller
Company: Ken Stumder, CPA
(Finance Director / Controller, Ken Stumder, CPA) |

Agree with Valerie. Mail merge is actually a simple and easy way to have a template populated with values from a financial report. It can also can be used for email templates and the like.

1281 views
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.