none
Linking Word to Excel RRS feed

  • Question

  • I have to create a report on a specific page in a Word Document (the final report) that involves pasting in charts from several different Excel Spread Sheets. 

    The challenges are that I can't have a VBA macro in any of the documents so I will have to have a "Master" document do all of the work. (The end users don't want any macros in the original documents)

    I have had training in VB 6.0 and understand VBA in Excel.  Is this even possible given these parameters?

    Thursday, May 16, 2013 4:30 PM

All replies

  • It sounds like Insert > Object might work for you. However, since your final solution can't involve any macro code it would be best if you asked your question on the user's forum. This forum is about programming Word. Here's a link to the Word Users forum: http://answers.microsoft.com/en-us/office/forum/word


    Kind Regards, Rich ... http://greatcirclelearning.com


    Thursday, May 16, 2013 6:03 PM
  • VBA = macros!!! So it's no good telling us you understand vba if you can't use macros.

    Unless you can link your Word document to Excel workbooks whose names, locations and chart names never change, this cannot be done automatically without vba. Provided  those requirements can be met, simply copy your charts and paste them into the Word document, using Paste Special with the 'Paste Link' option. From then on, whenever the charts update in Excel, they will update in the Word document.


    Cheers
    Paul Edstein
    [MS MVP - Word]

    Thursday, May 16, 2013 11:33 PM
  • Hello,

    Thanks for your participation in this forum.

    As Rich suggested, since you don't want to use programmatical method for your issue, the more appropriate forum to ask for help is http://answers.microsoft.com/en-us/office/forum/word

    This thread will be moved to Off-topic. Your understanding will be appreciated.

    Regards,


    Damon Zheng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, May 20, 2013 7:08 PM