Hi.

Not even sure if this is possible in VBA but here we go.

I'm the proud(?) recipient of a number of poor quality graphs, in PDF format from which i need to extract some data. The method i'm currently using is to 'print screen' each graph into a bitmap, which is then loaded onto a form.

several 'mousedown' events are captured to allow the user to pick out the ends of the axis. Then each click switches to being a data point.

Many of the graphs are not fully square, while i have managed to 'correct' for this what i'd like to be able to do is have the use mark both ends of the horizontal axis, then have the program rotate the image a few degress to level this axis so it is actually horizontal.

typically this rotation is less than 15 degress or so.

the objective is to make it a bit easier to see the lines and data points in the correct relationship, which should making picking out the data points a bit easier.

the code i'm working with simply loads the image, its the rotation i've no idea over.

additionally is it possible to draw lines etc over the top of a picture in vba?