Convert cell text to image

[princess:)]

Hello, Does anyone have a brilliant way to convert a text in a cell to image in the adjacent cell? For eg I have the name 'Tom' in cell A1 and would like to convert this and store it as an image that displays Tom in cell b2

The point is i need Tom to be stored as an image somewhere so that i can use it for mail merge using it as an image

 

[VoG]

Hi. Click in A1, hold down Shift, select Edit > Copy Picture, click in B2, Edit > Paste.

 

[princess:)]

tks, that was a quick reply. i tried it and it works. (i was trying a way to use it for mail merge)
will be possible to create the image and also save it as a file with the same file name as A1?

 

[VoG]

See if this helps http://www.mrexcel.com/forum/showthread.php?t=233108

 

[princess:)]

Hello again. I checked the thread you suggested. I am not very familiar with VBA but I tried it. And its not giving the output that i want. I want to be able to:

1. Firstly copy a cell value as an image file to a specific location in C drive
2. Secondly the image file name should be the same as the cell value
3. Thirdly the adjacent corresponding cell should contain the link address of the image file location

Pleeeeese help

 

[baimage]

it is not difficult to convert text to image if you use c# codes i guess. here is some you might find it is helpful to your problem. i find vba interesting too.