by Rajneesh Noonia (6 Submissions)
Category: Custom Controls/Forms/Menus
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(15 Votes)
Intellisense in scripting languages like vbscript is like a dream for script programmers. This goal of this project is to provide vbscript editor with intellisense like it was available in most of Microsoft language editor. The control uses the type library refrence to explore the public methods and function 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 xml file. The Script property of control will return the pure vbscript which can be executed using the Microsoft Script Control.
Assumes
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
Below is the output of Script Editor
Dim pConnection 'As ADODB.Connection
Dim pRecordset 'As ADODB.Recordset
Set pConnection = CreateObject("ADODB.Connection")
pConnection.Open("Query String Here","User ID","Password")
Set pRecordset = pConnection.Open("SQL Query Here")
MsgBox(pRecordset.RecordCount)
Developer continues to code like in vb 6.0 and the editor automatically convert the syntax to vbscript.
For example developer code
Dim pConnection As ADODB.Connection
And the editor will convert it to
Dim pConnection 'As ADODB.Connection
Which is equivalent to
Dim pConnection in vbScript
VBcoders
