I have a process which is repeated often which I would like to automate using macro.
I have several graphs which I copy from a program into work.
I then need to right click on the picture and select "edit picture" to convert it to a word drawing.
I then do various alterations, i.e. changing font of various texts and grouping all lines of a graph and resizing the graph
The same thing is done every time, and there are always the same number of lines in the graph, similar text in the same locations.
Can I automate this so I don't have to do this repetitive tast over and over? I am alright at using excel macro, but I find the word macro harder to grasp, and the editiing of pictures I fear may be hard to do.
Any help would be appreciated.
Kind regards
I have several graphs which I copy from a program into work.
I then need to right click on the picture and select "edit picture" to convert it to a word drawing.
I then do various alterations, i.e. changing font of various texts and grouping all lines of a graph and resizing the graph
The same thing is done every time, and there are always the same number of lines in the graph, similar text in the same locations.
Can I automate this so I don't have to do this repetitive tast over and over? I am alright at using excel macro, but I find the word macro harder to grasp, and the editiing of pictures I fear may be hard to do.
Any help would be appreciated.
Kind regards