Text to Image?!

.
If you can load your text into an Excel sheet, this macro will save it as a .JPG to the desktop :

Please Login or Register  to view this content.

Originally Posted by Logit

.
If you can load your text into an Excel sheet, this macro will save it as a .JPG...[snip]

:slaps forehead: of course! I even wrote a module about a year ago to capture part of an excel sheet to an image for end user approval (That probably sounds stupid - why not just show the excel sheet? - Because it was in a separate workbook to the Excel system that displayed the image)

I just didn't think to apply that logic to this scenario. Thanks for reminding me Logit - reps.

This method (text -> worksheet -> image) would work but it would be slow. I would be interested if there are any alternative options that would be faster.

(I am guessing it would be all but impossible to push the text into an image in memory as a byte array? Because each character would need to be represented as a set of bytes that would make up the pixels for that character - reverse OCR if you will)

.
I'm not aware if the process can be made faster.

It goes without saying that the macro provided would be just one portion of the workbook. You would create other macro/s that will provide the use of a FileDialog control for locating
the TEXT file to be converted. Or if the TEXT file is the same with new data each time, simply access that file then copy the range/s desired and paste to the Excel Sheet, then automate the process of converting to an image.

The above process will take a second or so ... not sure how you could make it faster.

Originally Posted by Logit

.It goes without saying that the macro provided would be just one portion of the workbook. You would create other macro/s that will provide the use of a FileDialog control for locating
the TEXT file to be converted. Or if the TEXT file is the same with new data each time, simply access that file then copy the range/s desired and paste to the Excel Sheet, then automate the process of converting to an image.

No problem. That part is already in place (I usually frame my threads around only the portion I am having trouble with rather than entire project)

Originally Posted by Logit

The above process will take a second or so ...

Probably. But the 2-3 seconds in my case would need to be multiplied by (potentially) several thousand files! (I just love writing code to save myself time by processing large batches )

Originally Posted by Logit

not sure how you could make it faster.

Same. (Well apart from my reverse OCR idea! lol)

So I will close the thread.