Click here to Skip to main content
15,867,453 members
Articles / Desktop Programming / MFC
Article

Adding VBScript and JScript support in your C++ applications

Rate me:
Please Sign up or sign in to vote.
4.91/5 (24 votes)
14 Jul 2002CPOL3 min read 411.4K   5.8K   146   91
Introduce to MSSCRIPT.OCX and calling JScript and VBScript in your C++ Application
Download ScriptDemo Demo Project - 31 Kb

ScreenShots

Introduction

I am always amazed to see how the script control (msscript.ocx) is fun to use and at the same time how C++ developers reacted when it's time to use. Maybe the extension (.ocx) make them feel, it's visual basic! In this article, I would like to remove those frontiers and give some new reasons for C++ developers to use it.

Description

To use either VBScript or JScript is fairly simple in a VB and C++ Application thanks to Microsoft's development efforts to create Windows Scripting technology. A developer only needs to know how to use the Microsoft Scripting ActiveX control (msscript.ocx) and how to pass value to a script method. For this reason, the first wrapper class that I want to identify is the CScriptObject. This wrapper is very simple to use and it provides most of the functionality that you will want to use in your application. It has a function to load script (text data) from a file or resource, get a list of methods name, selecting script language and to the execute function and statement. This class has no dependencies on MFC and can also be used in a console application. 

First of all to call a script it is important to know that VBScript and JScript deal only with VARIANT parameters. This is the reason I created the CSafeArrayHelper class. The

CSafeArray
helper wrapper class allows you to create parameters that you will pass to your script function.

class CSafeArrayHelper
{
    public:
        CSafeArrayHelper();
        ~CSafeArrayHelper();

    bool Create(VARTYPE  vt, UINT  cDims, UINT lBound, UINT cCount);
    bool Destroy();
    UINT GetDimension();

    bool Attach(LPSAFEARRAY psa);
    bool AttachFromVariant(VARIANT* pVariant);
    LPSAFEARRAY Detach();
    LPSAFEARRAY GetArray();
    bool AccessData(void FAR* FAR* pvData);
    bool UnaccessData();
    bool Lock();
    bool Unlock();
    bool PutElement(long lIndices, void FAR* vData);
    bool GetElement(long lIndices, void FAR* vData);
    VARIANT GetAsVariant();

    protected:
    LPSAFEARRAY    m_pSA;

    private:
};
It provides the exact same features that you will want to use with SAFEARRAY object but its usage may be simpler for some of us (like me!). The function GetAsVariant may be useful in case when you want to view the type of data that was encapsulated in your SAFEARRAY. This function could not provide ways to read all data types since the SAFEARRAY Data type (fFeatures) didn't implement it. Nonetheless to say, this function do a guess on the data types.

How to use

First to use this control, I will recommend you to take a look at the documentation for VBScript and JScript to know all you can do within your script function.

Writing a Script function

Let's say we want to create a simple function to convert temperature from Fahrenheit to Celsius.

In VBScript write:

VBScript
Function Celsius(fDegrees)
   Celsius = (fDegrees - 32) * 5 / 9
End Function
or in JScript write:
JavaScript
function Celsius(fDegres)
{
   return (fDegres-32)*5/9;
}
To call this function, one only needs to store each parameter into VARIANT. Since your function (method) can have more than one parameter, a SAFEARRAY is needed to encapsulated them. In that latter case, you may want to view the parameter count for the array passed to your function by checking the .length property for string function or by some other means.
JavaScript
function CountParam(aParam)
{
    var strPresent = "Parameter is : " + (aParam.length>0 ? "Present": "Not present");
    return strPresent;
}
The same technique may be used in VBScript. This allows you to detect variable length argument at run time. To call a function without argument, a SAFERRAY is created but without parameter.

Calling a Script function

Your code can be as easy as this:

void CScriptDemoDlg::OnBtnExecute() 
{
    CString strParam, strProc;
    m_ctlParameter.GetWindowText( strParam );
    m_ctlFunctions.GetWindowText( strProc );

    CSafeArrayHelper sfHelper;
    try{
        _variant_t var;
        if (strProc.IsEmpty())
            sfHelper.Create(VT_VARIANT, 1, 0, 0);    // (void) parameter
        else
        {
            sfHelper.Create(VT_VARIANT, 1, 0, 1);    // 1 parameter
            var = _bstr_t(strParam);
        }
        sfHelper.PutElement(0, (void*)&var);    // parameter1 -> index 0
        LPSAFEARRAY sa =  sfHelper.GetArray();
        _variant_t varRet;
        if (m_ScriptObj.RunProcedure(strProc, &sa, &varRet))
            m_ctlResult.SetWindowText( (LPCTSTR)(_bstr_t(varRet)) );
        else
        {
            CString strError = m_ScriptObj.GetErrorString();
            m_ctlResult.SetWindowText( strError );
        }
    }
    catch(...)
    {
        CString strError = m_ScriptObj.GetErrorString();
        m_ctlResult.SetWindowText( strError );
    }
}

Some Ideas

Some of the ideas that you may want to try.
  1. You may want to have your script acts like a plugin, one suggestion is to have a resource script into a DLL and loads it at runtime (you may also have it part of your application). In that case, you will want to have specific module-related function, like: InitModule, ReleaseModule, btnOK_Click, btnCancel_Click, LoadUserData(strUsername), SaveUserData(strUserData), etc... and each of your DLL will have to implement them.

  2. You may have your script to do a complete task and you will load the script file based on the task (the CScriptObject class can load a script file for you!).

    Example: This script starts the "Calculator" program.

    JavaScript
    function StartCalc()
    {
     var WshShell = new ActiveXObject("WScript.Shell");
     var oExec = WshShell.Exec("calc");
         WshShell = null;
    }
  3. You may want to create ActiveX object that lives longer than for a function call:
    JavaScript
    var XML_Obj;
    function StartModule()
    {
     XML_Obj = new ActiveXObject("Msxml.DOMDocument");
     XML_Obj.async = false;
    }
    function StopModule()
    {
     XML_Obj = null;
    }
    function LoadSettings(strFilename)
    {
     XML_Obj.load(strFilename);
    }
  4. There are cases that you may want to execute the script code directly, just add the code, do not create a function...try it for fun!

References

Microsoft Windows Script Control
VBScript Documentation
JScript Documentation

History

15 July 2002 - updated demo fixed VC6 and VC7 issues

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
United States United States
Ernest is a multi-discipline software engineer.
Skilled at software design and development for all Windows platforms.
-
MCSD (C#, .NET)
Interests: User Interface, GDI/GDI+, Scripting, Android, iOS, Windows Mobile.
Programming Skills: C/C++, C#, Java (Android), VB and ASP.NET.

I hope you will enjoy my contributions.

Comments and Discussions

 
GeneralRe: ScriptObject not instantiated Pin
Anonymous22-Jul-05 0:21
Anonymous22-Jul-05 0:21 
GeneralCreate an ActiveX object in VC++ Pin
Anonymous27-Apr-05 10:28
Anonymous27-Apr-05 10:28 
GeneralCreate an ActiveX object in VC++ Pin
Nahomi13-Apr-05 9:43
Nahomi13-Apr-05 9:43 
GeneralRe: Create an ActiveX object in VC++ Pin
Ernest Laurentin13-Apr-05 13:12
Ernest Laurentin13-Apr-05 13:12 
GeneralCalling VBScript from standalone code Pin
grantepalmer4-Apr-05 17:52
grantepalmer4-Apr-05 17:52 
QuestionHow can I receive a VBScript integer array or how can i change the type of the VARIANT parameter Pin
Nahomi21-Dec-04 6:36
Nahomi21-Dec-04 6:36 
AnswerRe: How can I receive a VBScript integer array or how can i change the type of the VARIANT parameter Pin
kamel28-Aug-06 5:15
kamel28-Aug-06 5:15 
GeneralTwo parameters Pin
fpdeguzman5-Feb-04 21:55
fpdeguzman5-Feb-04 21:55 
hey gud day to all! please help me. how can i modify the code to pass more than one parameter to CScriptDemoDlg::OnBtnExecute()? i have difficulty adding another parameter. Confused | :confused:

try{
_variant_t var;
if (strProc.IsEmpty())
sfHelper.Create(VT_VARIANT, 1, 0, 0); // (void) parameter
else
{
sfHelper.Create(VT_VARIANT, 1, 0, 1); // 1 parameter
var = _bstr_t(strParam);
}
sfHelper.PutElement(0, (void*)&var); // parameter1 -> index 0
LPSAFEARRAY sa = sfHelper.GetArray();
_variant_t varRet;
if (m_ScriptObj.RunProcedure(strProc, &sa, &varRet))
{
m_ctlResult.SetWindowText( (LPCTSTR)(_bstr_t(varRet)) );
BOOL bTemp = atol((LPCTSTR)(_bstr_t(varRet))); // Freddie
}
else
{
CString strError = m_ScriptObj.GetErrorString();
m_ctlResult.SetWindowText( strError );
}
}

thanks!
regards... Smile | :)
GeneralRe: Two parameters Pin
rizwan8210-Jul-04 3:21
rizwan8210-Jul-04 3:21 
GeneralRe: Two parameters Pin
Anonymous12-Jul-04 15:33
Anonymous12-Jul-04 15:33 
GeneralRe: Two parameters Pin
fpdeguzman12-Jul-04 15:38
fpdeguzman12-Jul-04 15:38 
GeneralGraphical Interface Pin
MicaS26-Jan-04 5:32
MicaS26-Jan-04 5:32 
GeneralRe: Graphical Interface Pin
Ernest Laurentin26-Jan-04 20:22
Ernest Laurentin26-Jan-04 20:22 
GeneralCompile prob (release mode only) Pin
Jason Troitsky27-Dec-03 4:01
Jason Troitsky27-Dec-03 4:01 
QuestionCan it run encoded script ? Pin
wangniu8-Dec-03 2:53
wangniu8-Dec-03 2:53 
QuestionHow do I receive a VBScript array??? Pin
johannks26-Nov-03 22:43
johannks26-Nov-03 22:43 
GeneralAutomation Server Support Pin
zkrr0110-Oct-03 9:40
zkrr0110-Oct-03 9:40 
GeneralAlert & Prompt Pin
DJMystic28-Aug-03 9:05
DJMystic28-Aug-03 9:05 
GeneralRe: Alert & Prompt Pin
Ernest Laurentin30-Aug-03 7:35
Ernest Laurentin30-Aug-03 7:35 
GeneralRe: Alert & Prompt Pin
DJMystic30-Aug-03 7:35
DJMystic30-Aug-03 7:35 
GeneralMulti-Threaded programs Pin
DJMystic27-Aug-03 2:59
DJMystic27-Aug-03 2:59 
GeneralRe: Multi-Threaded programs Pin
Ernest Laurentin30-Aug-03 7:30
Ernest Laurentin30-Aug-03 7:30 
Generalnew & delete with return values Pin
DJMystic25-Aug-03 11:46
DJMystic25-Aug-03 11:46 
GeneralRe: new & delete with return values Pin
Ernest Laurentin26-Aug-03 14:22
Ernest Laurentin26-Aug-03 14:22 
GeneralRe: new & delete with return values Pin
DJMystic26-Aug-03 20:09
DJMystic26-Aug-03 20:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.