macro to convert image to shape to edit text inside it

[MKLAQ]

Hi experts

I search for macro to convert the image to shape until I can edit some text inside the image .

actually I convert file from pdf to excel and when open the EXCEL file some objects shows as image I can't edit it

so when I select the object show shape name Group 3223 and inside him picture name Picture 29 .so is threre any macro deals with images by convert to shape to edit the text inside the picture?
thanks

 

[6StringJazzer]

Converting information in an image (like a .jpg) to text requires an external application like OCR software. There are no features in VBA that can do this.

Can you show an example of the kind of image you are talking about?

 

[MKLAQ]

as you know the shape can edit . there is no way to convert image JPG to shape by vba instead of external application like OCR software as you said ? I no know what you want as example to show what I ask for it. do you mean to see picture?

 

[Dan_W]

I think that would be helpful, please. My immediate question when I read your explanation was - what kind of shape is it? One that can be easily drawn from the Excel shapes gallery?

 

[6StringJazzer]

You said you want to convert an image to a shape with text.

Please show us an example of the kind of image you want to convert.

 

[MKLAQ]

what kind of shape is it? One that can be easily drawn from the Excel shapes gallery?

is there many types shapes?
I'm talking about oval or Rectangle .

 

[MKLAQ]

You said you want to convert an image to a shape with text.

yes

Please show us an example of the kind of image you want to convert.

ok but what do you want to know about the picture? if it's type is jpg and rarely png and if you want to see the picture it's easy to attach picture as example.

 

[6StringJazzer]

ok but what do you want to know about the picture? if it's type is jpg and rarely png and if you want to see the picture it's easy to attach picture as example.

What I want to know about the picture is what it looks like. If it's easy to attach it, then just attach it. This is the third time I have requested this.

 

[Dan_W]

Well there are this many in the gallery...

As we have both already explained and asked a few times for an example to wrap our heads our heads around (because it's really not easy to fully grasp what you're trying to do...), the more info you can give, the more likely we might be able to come up with a helpful solution. But if you can't, that's fine. Here's the solution: use the macro recorder. It might be able to generate the VBA code for you. Just set it to record, undertake the task manually, stop it, clean the code, and see how that goes.

 

[6StringJazzer]

undertake the task manually, stop it, clean the code, and see how that goes.

There is no way to manually convert text in an image to actual text except by reading it then typing it in. That won't work for a macro. Unless there is something I am missing (which is why I want to see an example), the only way to do this is with an API to OCR software.