View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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 ?