XL98: Syntax Error Running Macro That Inserts WordArt

CAUSE

This problem may occur if the text in the WordArt object you insert contains any quotation marks. When you record the commands to create this kind of WordArt object, Microsoft Excel 98 Macintosh Edition may not insert the correct combination of quotation marks in the recorded code, and the macro does not work.

For example, if you record the steps to create a WordArt object that contains the following text the recorded code may look similar to the following:

   ActiveSheet.Shapes.AddTextEffect(msoTextEffect3, _
      "We're the "Wright" Solution!", "Arial", 18.00, msoFalse, _
      msoFalse, 69.75, 166.50).Select
				

Note that the word "Wright" is enclosed in quotation marks.

   ActiveSheet.Shapes.AddTextEffect(msoTextEffect3, _
     "We're the ""Wright"" Solution!", "Arial", 18.00, msoFalse, _
      msoFalse, 69.75, 166.50).Select