Creating JPG Files from a List in Excel

Hello,

Is there a way for excel/VBA to take a list from excel and turn them into graphics like .jpg or .png files? I have a lot of "Heading" images to make and think this could be an easy way to do it if possible

For example, in Column A, I would have the filename and Column B I have the Text that I would like to create as an Image. The macro would work down the list until each row had it's own image file in a specified folder. I need the Header to be 400pixels wide by 100pixels high and be able to customize the background color and font color.

Hope this isn't too crazy of an ask!

My thought is that I could format the cell exactly how I'd like it. For example, I can kind of do what I want to be done by coloring the cells in Column B, formatting the text, making the column width "47.5" and the row height "15". Then if I go to Home, Click the "Copy as Picture" button, Paste, then right click and do save as Picture, it does what I'd like. However, recording a macro to do this does not work.

.

Please Login or Register  to view this content.

I don't know if the images in the sheet are enough for you?

Please Login or Register  to view this content.

Artik

Here is a project from my tool box. You'll need to input the image file name in Col D so the macro will know which image to paste from your folder containing the images.

Please Login or Register  to view this content.

You'll need to edit the path to suit and make adjustments for the image size.

#10. Your macro did work after all. Thank you! For whatever reason, my version of excel did not like "ThisWorkbook.ActiveSheet" and I had to change to Set sht = ActiveWorkbook.Worksheets("Sheet1").

I'll have to check out lrfanview. Do you mind sharing the code while I've got you? Could be a good weekend project for me.

I noticed that when my images get saved it creates a white border around it. Maybe this is one of the issues you've noticed with Chart Objects? If not, is there any code that could eliminate that?

Attachment 858660

Here is what I came up with thanks to your help. You may have to step though some of the code since our directories won't match. The issue I am having trouble with now is just the outline around the graphic. When it gets saved to the folder, it has a white border around the image. However, if I manually "copy as picture" and paste as picture within the workbook, there is no border.

Try the emf format, which more faithfully reproduces the cell image. The code is a bit long.
In one standard module code from Stephen Bullen:

Please Login or Register  to view this content.

In the second standard module:

Please Login or Register  to view this content.

Artik