Microsoft KB Archive/181468

= XL98: Syntax Error Running Macro That Inserts WordArt =

Article ID: 181468

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181468



SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, if you insert a WordArt object while you are recording a Microsoft Visual Basic for Applications macro, and then run the macro, you may receive the following error message:

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

We're the "Wright" Solution!

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.



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 sample code to the following: ActiveSheet.Shapes.AddTextEffect(msoTextEffect3, _    "We're the ""Wright"" Solution!", "Arial", 18.00, msoFalse, _      msoFalse, 69.75, 166.50).Select Note the second set of quotation marks around the word "Wright."



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: XL98

Keywords: kbmacro kbprb kbdtacode KB181468

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.