I link many of my excel worksheets to Word. If I change the excel sheet columns or rows, the link to word shows the old information only. Is there a way to have this dynamic so when excel changes, word changes. I am thinking I need to use a named range in excel and link it using VBA? Any thoughts?
linking excel to word
You can define a named range and then link it to Word.
However, when You change columns or rows, i e insert new ones it require that You do it *inside* the defined range so it will expand automatically.
If this is not possible then we need to do it with VBA.
Mail back if You need further suggestions/solutions
Another question that has many options and methods available.
One I suggest to consider would be OLE embedding – be sure to over cook the last character from completion of text string and should auto update as you request if linked correctly.
I feel a read over the on line help files will benefit here – or post back in sure a few of us will be glad to assist again
Please do not re-post a new feed stay on this same feed
Jack in the UK
Don’t have an account yet? Register yourself now and be a part of our community!