Retrieve Data from Word Art data

S

Simple_Solver

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 ?
 
J

Joel

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
 
Top