Click here to Skip to main content
11,641,087 members (63,602 online)
Click here to Skip to main content

VbScript Editor With Intellisense

, 13 Aug 2007 CPOL 147.6K 6.5K 58
Rate this:
Please Sign up or sign in to vote.
VbScript Editor With Intellisense
Screenshot - ScriptEditor.gif

Introduction

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.

Background

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 '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 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 ' before As):

Dim pConnection 'As ADODB.Connection 

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.

History

  • 13th August, 2007: Initial post

License

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

Share

About the Author


You may also be interested in...

Comments and Discussions

 
Questionthis is a very good Editor Pin
Member 118118713-Jul-15 6:26
memberMember 118118713-Jul-15 6:26 
BugType Mismatch Pin
essco@execpc.com27-Aug-14 17:06
memberessco@execpc.com27-Aug-14 17:06 
GeneralNot able to run Vbscript intel Pin
chinnu198817-May-11 7:41
memberchinnu198817-May-11 7:41 
GeneralRe: Not able to run Vbscript intel Pin
eda200028-Sep-11 21:52
membereda200028-Sep-11 21:52 
QuestionHas anyone been able to upgrade it? Pin
deafwing22-Feb-10 8:58
memberdeafwing22-Feb-10 8:58 
GeneralGetting error even after referencing olelib.tlb Pin
BrianA28-Dec-09 7:46
memberBrianA28-Dec-09 7:46 
GeneralNeed a debugger too? Get Vbsedit! Pin
Member 435098930-Sep-09 4:07
memberMember 435098930-Sep-09 4:07 
GeneralMy vote of 1 Pin
ThisSignUpBullShitIsGay29-Jan-09 4:20
memberThisSignUpBullShitIsGay29-Jan-09 4:20 
GeneralSky Player Pin
Vic Radford26-Jan-09 10:22
memberVic Radford26-Jan-09 10:22 
Questionscripteditor, how you instal it? [modified] Pin
dangcao11-Jul-08 8:44
memberdangcao11-Jul-08 8:44 
AnswerRe: scripteditor, how you instal it? Pin
mdanh20026-Jan-09 18:44
membermdanh20026-Jan-09 18:44 
GeneralWhen executing I'm not getting Intelesense window to display methods Pin
sri_200827-May-08 8:23
membersri_200827-May-08 8:23 
Questionpls..help.me..? Pin
vijaysaxena22-May-08 9:49
membervijaysaxena22-May-08 9:49 
QuestionMISSING: Edanmo's OLE interfaces & functions v1.81 Pin
chopeen22-Aug-07 22:47
memberchopeen22-Aug-07 22:47 
AnswerRe: MISSING: Edanmo's OLE interfaces & functions v1.81 Pin
Rajneesh Noonia23-Aug-07 1:00
memberRajneesh Noonia23-Aug-07 1:00 
GeneralRe: MISSING: Edanmo's OLE interfaces & functions v1.81 Pin
chopeen23-Aug-07 2:06
memberchopeen23-Aug-07 2:06 
You even wrote it in the article. Sorry, I missed it.
GeneralVERY Cool! [modified] Pin
Graham Downs20-Aug-07 22:39
memberGraham Downs20-Aug-07 22:39 
GeneralRe: VERY Cool! Pin
Graham Downs21-Aug-07 1:10
memberGraham Downs21-Aug-07 1:10 
GeneralRe: VERY Cool! -- Will someone please convert this? Pin
SMerrill886-Mar-09 7:02
memberSMerrill886-Mar-09 7:02 
Generalwonderful Pin
pita200013-Aug-07 8:18
memberpita200013-Aug-07 8:18 
GeneralDamn... vb6 Pin
thund3rstruck13-Aug-07 7:20
memberthund3rstruck13-Aug-07 7:20 
GeneralRe: Damn... vb6 Pin
Alex Riedel20-Aug-07 21:12
memberAlex Riedel20-Aug-07 21:12 

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

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

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150731.1 | Last Updated 13 Aug 2007
Article Copyright 2007 by Rajneesh Noonia
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid