+ Reply to Thread
Results 1 to 2 of 2

VBA- using entered or chosen information in excel to auto-populate a sentence in word.

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    ny
    MS-Off Ver
    2007
    Posts
    1

    VBA- using entered or chosen information in excel to auto-populate a sentence in word.

    For Example...

    In Excel:

    Question Answer
    What is his Name? John
    How many apples did he buy? 8
    How much did the apples cost? 50

    In Word: John is in cell b2, 8 is in b3, 50 is in cell b4

    John bought 8 apples totaling $ 50 dollars.

    Based on the information typed in the answer column (excel spreadsheet) I would want a word document to automatically generate a sentence.

    Is this possible?
    Last edited by metfan755; 07-02-2014 at 08:28 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA- using entered or chosen information in excel to auto-populate a sentence in word.

    Yes it is. You'll need to look at automating word from excel using vba.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code to open word and auto populate labels from excel?
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 03:56 AM
  2. Auto populate multiple cells with a value entered in one Cell
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2012, 07:18 AM
  3. Replies: 2
    Last Post: 10-30-2012, 06:08 PM
  4. Replies: 1
    Last Post: 04-26-2012, 06:42 AM
  5. auto populate cell when selected drop down item chosen
    By palmer19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2010, 07:16 AM

Tags for this Thread

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