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

 

[Dan_W]

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.

No, of course, but I figured if we're not going to get anymore information, see if OP can do whatever OP is trying to do (still don't understand) and maybe the Macro Recorder can make sense of it.
What I had wondered is if there were images from this PDF (which again, I don't understand, but anyway), and then one could paste these images as the 'fill' for a shape, AND THEN edit the text of the shape. I had (generously) interpreted the whole text part as perhaps meaning that OP would ADD the text later to an image/shape... But again.... still not sure what's happening.

 

[6StringJazzer]

What I had wondered is if there were images from this PDF (which again, I don't understand, but anyway)

Yeah, I don't get it either. But I have Adobe Acrobat Professional (a very old version but it still works) and it has a feature called Export Images where any image in the file will be exported as a JPG file. I am thinking there is something like that going on.

 

[MKLAQ]

ok Guys

as I said when convert file PDF to EXCEL it shows some parts as shapes and the others show picture the whole picture contains some picture and shapes . when I try edited some pictures I've found the pictures become shapes(Rectangle ) as show in bottom the picture DATE I can edit it ,but MAFAZA, GOODRIDE,FREEZONE,B it shows as one picture that's why I ask if I can make this picture as shapes by specify each picture individaully to edited by converting to Rectangle .

 

[6StringJazzer]

I ask if I can make this picture as shapes by specify each picture individaully to edited by converting to Rectangle .

Your original question was how to extract the text from a picture to make it editable text. Now you seem to be asking how to convert one image into multiple shapes.

You use any graphic editor to break the image into multiple images. However you cannot convert an arbitrary image into an Excel shape (like a rectangle).

You cannot extract text from an image into editable text without OCR software. There may be multiple options to do this but I have never integrated OCR into Excel.

So to summarize, there is no way to take an image and convert it to an Excel rectangle with the text "GOODRIDE" in the middle without a lot of custom software integration that may not even exist.

 

[Dan_W]

Is this what you're after?

 

[Dan_W]

Ok, @6StringJazzer beat me to it, but if that's what you're after I had to do that manually. That, and I don't know how you would go about doing it programmatically without some kind of algorithm/AI. Also, it's not really what you were originally asking. I agree with @6StringJazzer - you can't extract text without OCR software of some description.

 

[MKLAQ]

Your original question was how to extract the text from a picture to make it editable text. Now you seem to be asking how to convert one image into multiple shapes.

there is no different question . what I want edit the picture whether by convert to shape or any thing else.

 

[MKLAQ]

Is this what you're after?

Looking at the picture seems this is what I want it .