Copy range from Excel Spreadsheet and paste into saved Word Document as picture

[chrisellis250]

Hello,

My current code below, copies data in a specific cell to a bookmark in a saved Word Document. Is there a way I could edit my code to past a Range (i.e. B2:G23) to the bookmark in the word document as a picture?

Please Login or Register  to view this content.

Any help much appreciated

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be edited to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[chrisellis250]

Hi Greg,

Many thanks for that - it works perfectly. Is there a way I could incorporate more ranges into the code, to paste other ranges of data as pictures to specific bookmarks in the document?

[chrisellis250]

Hi Greg,

Many thanks for that - it works perfectly. Is there a way I could incorporate more ranges into the code, to paste other ranges of data as pictures to specific bookmarks in the document?

[Greg M]

Hi again,

Thanks for your feedback. I think the following (untested) code should do what you need:

Please Login or Register  to view this content.

As before, the highlighted values may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[chrisellis250]

Thanks Greg, that is excellent. Much appreciated.

One final thought after testing, is there a way the code could be amended to copy a single cell, or a range to a bookmark in the same word document but where it is pasted as text, as opposed to picture.

So the code would paste some ranges as pictures and some as text?

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

I think that something along the following lines should do what you need:

Please Login or Register  to view this content.

If you are likely to be dealing with a large number of ranges, it would probably be much easier to enter all of the Range / Bookmark Name / Copy Method information on a worksheet, and to pass all of that information to the above routine in the form of an array.

Hope this helps - as always, please let me know how you get on.

Best regards,

Greg M

[chrisellis250]

Hi Greg - one final thought. Is there a way to define the size of each picture?