How to grap part of the Excel graph board as a kind of 'screendump' into Word by VBA

KeldSor 351 Reputation points
2023-11-01T15:15:40.8733333+00:00

I have a family tree drawn i Excel using reacangles, triangles and arrows.

I want a part of that tree 'copied' as an image into Word - not as a 'screendump' because I want a bigger part of the tree than the what's seen on the screen and it should be readable too when placed on as landscape image on my A4-page in Word.

I have a solution with 'just' a screendump to the clipboard to paste as a picture/image where I want in the Word text, but the picture/image is to small to read for the users and if I 'zoom in' closer I loose overview of the tree.

How can I 'dump' a little more than what's seen on the screen to the clipboard by VBA code ?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,989 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.