Convert Large Number of Cells into Seperate JPEGs

Hi guys.

So, basically I am trying to find out if there is a way that I can go from Cell A1, down to say Cell A1000, and make a separate JPEG for each of the cell's contents. Is this possible? Presumably it would require some sort of VBA code or a macro, but I am not sure how to go about this, so I am just trying to find out if this is even feasible.

If you are wondering why I want to do this, it is because I am trying to get a bunch of product names as seperate JPEGs that can then be put on a smart watch and swiped one by one.

Thanks if you can help.

Yeah. I will make an example file and attach it. The attachment basically shows what I would like each cell (and thus JPEG) to look like (i.e. product name, and then quantity below it).
As far as the file names go, if they are just the contents of the cell, then that's awesome. The minimum requirement is that the new file names preserve the order (i.e. which row was first, which second etc...).
Hopefully that makes sense.

Originally Posted by kev_

Is this how you want the image to look?

Yeah, Ideally.

Thanks a bunch. Huge, Huge thanks.

Hi. I just tried the second piece of code you sent and I got this popup:
https://gyazo.com/90dcbb682b46a93352...de7f5d248c6ea7

I will send the file over in case it's just me being a dumbass (I used CHAR(10) for the line break and then pasted as values).

That's awesome! (it worked now). Just a couple of things though. The image doesn't show the last term (i.e. the quantity: https://gyazo.com/777ff848d7ea376b7b...e89e1135c01691 ). Also the image is quite small. Is it possible for me to increase the size of the image, and if I change the ".jpg" in the code to ".png" will that make it higher quality or do I need to do something else if I want that? Thanks ever so much!

Ok, solved the issue of the quantity not showing up (just had to wrap the text in the cells properly). I guess now it's just about potentially finding a way to make a bigger + higher quality image if that's possible.

Ok, just figured out that all I need to do for that is to make the text in the cells larger before I run the code. I will attach the file just so you can see how the end result of your code looks like now. Thank you so so so so much. This is definitely the kick up the *** I needed to realise that I have got to learn how to use VBA. Honestly awesome stuff. Thanks a bunch once again.

Oh, actually, I do have one question now that I have thought about things more fully.

Let's say in the column next to each cell, I had the name of the company buying a product. Would it be possible to "append" this to the front of the text file names without having them have images created for themselves? If this is a hassle to do, then absolutely no worries, because what you have done is already amazing and is more than good enough, but I just realised that by the time I can learn VBA well enough to edit the code sufficiently to do something like this, it would probably be at least a few months down the road. I also made some adjustments to the code as I had more time to think about how I wanted the formatting to be. Attaching the most recent version now.