XL97: Syntax Error Running Macro That Inserts WordArt

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, if you insert a WordArt object while you are recording a Visual Basic for Applications macro, and then run the macro, the following error message may appear:

Compile error:
Syntax error

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 97 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

We're the "Wright" Solution!

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

RESOLUTION

To resolve this problem, add an additional set of quotation marks around the text that you want to appear in quotation marks. For example, change the example code to the following:

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

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Additional query words: XL97

Keywords : kberrmsg kbprg xlvbahowto xlvbainfo xldraw
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb