Microsoft KB Archive/212640

From BetaArchive Wiki
Knowledge Base


Article ID: 212640

Article Last Modified on 10/11/2006



APPLIES TO

  • Microsoft Word 2000 Standard Edition



This article was previously published under Q212640


SYMPTOMS

When you attempt to run a macro that was converted from WordBasic to Visual Basic for Applications and that contains code that uses the Open statement in combination with a function call to retrieve the value for the file name argument, the following error message may appear:

Compile error:

Syntax error

After you open and save a template in Microsoft Word 2000 that contains the following macro from an earlier version of Microsoft Word:

Sub MAIN()
   Dim Arg1$
   Arg1$ = "A"
   ' This line contains a Function Call.
   Open Call("Library.OutputFile$", Arg1$) For Append As 2
   Close 2
End Sub
                

Word converts the macro to the following, and the error message appears when you try to run the macro:

Public Sub MAIN()
   Dim Arg1$
   Arg1$ = "A"
   ' This line has been converted to a procedure Call and will cause
   ' the error mentioned earlier in this article.
   Open (WordBasic.Call "Library.OutputFile$",)'", Arg1$) For Append As 2
   Close 2
End Sub
                

CAUSE

When the WordBasic macro is converted, the function call is converted to a procedure call.

WORKAROUND

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
For more information about how to use the sample code in this article, click the article number below to view the article in the Microsoft Knowledge Base:

212536 OFF2000: How to Run Sample Code from Knowledge Base Articles


To work around this problem, follow these steps:

  1. Open the template that contains the macro.
  2. On the Tools menu, point to Macro and click Macros.
  3. Click the macro and then click Edit.
  4. Edit the converted macro and change the procedure call back to a function call.

    For example, change this line of code:

    Open (WordBasic.Call "Library.OutputFile$",)'", Argl$) For Append As 2
                        

    to this:

    Open WordBasic.Call("Library.OutputFile$", Arg1$) For Random As 2
                        


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For additional information about getting help with Visual Basic for Applications, click the article numbers below to view the articles in the Microsoft Knowledge Base:

212623 WD2000: Macro Programming Resources


226118 OFF2000: Programming Resources for Visual Basic for Applications



Additional query words: vb vba vbe

Keywords: kbbug kbdtacode kbpending kbprogramming KB212640