Does VBScript allow named arguments in function calls?

by

VBScript doesn’t support named arguments to procedures and functions. You need to change the argument list to positional:

Workbooks.OpenText Filename_Argument, xlMSDOS, ...

VBScript also doesn’t recognize Excel constants (like xlMSDOS), so you need to look them up and replace them with their numeric values:

Workbooks.OpenText Filename_Argument, 3, ...

And you must use explicit object references:

objExcel.Workbooks.OpenText Filename_Argument, 3, ...

The Excel Macro Recorder puts named arguments into positional order, so you can just delete the parameter names. Optional parameters that you don’t want to specify can be omitted, e.g.:

x = Function(Var1, , Var3)
'                 ^
'                 `- omitted optional 2nd parameter

More Related Contents:

  1. Can I pass an argument to a VBScript (vbs file launched with cscript)?
  2. Getting current directory in VBScript
  3. Read and write binary file in VBscript
  4. Read and write into a file using VBScript
  5. Creating multi-select list box in VBScript [closed]
  6. Launch programs whose path contains spaces
  7. Parameterized query in Classic Asp
  8. Access network share from within VBScript eg FileSystemObject
  9. ByRef and ByVal in VBScript
  10. Lists in VBScript
  11. Order of Files collection in FileSystemObject
  12. VBScript: What is the simplest way to format a string?
  13. VBScript to send email without running Outlook
  14. How can I use Clipboard in vbscript? [duplicate]
  15. How to set delay in vbscript
  16. Find my own process ID in VBScript
  17. Passing-variable-from-vbscript-to-batch-file with arguments
  18. Can I pick up environment variables in vbscript WSH script?
  19. Passing Parameters to a Stored Procedure using ASP
  20. How can I show a message box with two buttons?
  21. WScript.Shell.Exec – read output from stdout
  22. How to use GetObject in VBScript
  23. How can I convert a VBScript to an executable (EXE) file? [closed]
  24. Vbscript list all PDF files in folder and subfolders
  25. Can not send mail using smtp.gmail.com, port 587 from vbs script
  26. MSGbox in VBS that updates with value of variable
  27. insert a variable to cmd command
  28. How can I use the common Save As dialog from VBScript?
  29. Create a folder in Outlook: error 800A0401 – Expected End of Statement
  30. VBscript error input past end of file

Leave a Comment