Intellisense in scripting languages like VBScript is like a dream for script programmers. The goal of this project is to provide VBScript editor with intellisense like it was available in most of Microsoft language editors. The control uses the type library reference to explore the
public methods and functions exposed in any com library. The script developer has to code like VB 6.0 language (
Dim pConnection as ADODB.Connection) and the editor will automatically convert the code into VBScript.
The complete VBScript alone with added references can be saved as an XML file. The Script property of control will return the pure VBScript which can be executed using the Microsoft Script Control.
How to run the code:
Open the group project and press F5 vbScriptEditor_Group.vbg.
If the project says missing Edanmo's OLE Interface…. Then add reference to olelib.tlb in TypeLib folder.
Converting Vb 6.0 Syntax to vbscript
Dim pConnection Dim pRecordset Set pConnection = CreateObject("ADODB.Connection")
pConnection.Open("Query String Here","User ID","Password")
Set pRecordset = pConnection.Open("SQL Query Here")
Developer continues to code like in VB 6.0 and the editor automatically converts the syntax to VBScript.
For example, the developer codes:
Dim pConnection As ADODB.Connection
And the editor will convert it to (It will automatically insert
Which is equivalent to:
Dim pConnection in vbScript
The Script property will return the pure VBScript.
ScriptRTF will return the coloured VBScript.
XMLProject will return the added references in the form of XML.
Make sure to post your comments and ratings for further developments and bug fixing.
- 13th August, 2007: Initial post