Hello everyone - I have managed to use Mr. Plow's fantastic script for using a VBA script to cycle through Word bookmarks and insert Excel range value. I have managed to get the script to work fantastically on text only copies. However I would also like to copy and paste charts as well as tables from named ranges. I was wondering how I could achieve this with a modification of the script that is found in this thread:
http://www.ozgrid.com/forum/showthread.php?t=148798&page=1 (post number 6)
Currently when I try to "autocopy" from a range that is a table I get the error: "Run-time error '94': "Invalid use of Null" on the following line:
strValue = Trim(Application.Range(strName).Text)
I don't believe it should be too hard to modify the script, but all my attempts have failed so far. If someone could advise me at least where I could start looking that would be fantastic.