+ Reply to Thread
Results 1 to 2 of 2

Need to automatically extract figures from excel data set to word template.

  1. #1
    Registered User
    Join Date
    01-21-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need to automatically extract figures from excel data set to word template.

    Hey all,

    my boss threw me this assignment and I don't know how to do this =(

    What I need is to automate this process: I have a data set on excel format and a word template. I need to generate reports based on some of the figures derived from the database (this can either be directly lifted from the database or through a form of analysis like averages etc.) But other than those figures, the rest of the word template remains the same.

    Does anyone know how to do something like this? I just need an idea on where to go reading up at.

    Thank you!

    Regards,
    Joshua

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need to automatically extract figures from excel data set to word template.

    read up on mail merge
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1