Retrieve Data from Word Art data
I added a word art object while recording a macro and got the code below.
The code to change the text or read the text would be similar to
Selection.ShapeRange.TextEffect.Text = "My text 1"
Your answer is Yes it is possible to extract textt from a word Art Object.
VLOOKUP will not work. A Macro or function can be writen to look at all the
word Art Objects and examine the text in the object.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/15/2007 by Joel Warburg
'
'
ActiveSheet.Shapes.AddTextEffect(msoTextEffect14, "My text", "Impact",
36#, _
msoFalse, msoFalse, 334.5, 240.75).Select
End Sub
"Simple_Solver" wrote:
Hi,
Is it possible to Extract Data from a Word Art pasted on Excel File
possibly containing data that needs to be used for Vlookup function ?
|