Copy image range excel to paint

I'm trying to get a range of cells content (format, content, images, etc) copied to paint so then it can be saved as .png in the directory where the workbook his. Searching on the web i found that a range can be exported to a graph in excel and then export this as a picture and save in the directory we want. In the search i came across with this code:

Please Login or Register  to view this content.

But everytime i try to run it, it exports the data range into a graph in the same sheet but then Runtime Error '76' Path not found. If i change the directory to C:\ it says i dont have permission. But what i really want is to create the graph, then it exports it to the same directory where the workbook is (IMPORTANT: this directory may change so it will be godd if the macro knows where to put it automaticly), and finally delete the created graph from the open workbook.

Try this...

Please Login or Register  to view this content.

Perfect. Thank you very much.

PS - just changed gif to png (cause like more this format) - it's perfect now.