Re: IDE or Editor for VBS?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Miyahn.

Thanks for the info. On MSE7 is true I cannot add references but I added
components to see the properties.

I usually use CRedit to do my vbscript but I will be using MSE and the VBE
from excel.

where in japan are you? i'm in Okinawa
Thanks for the help.
Rafael



"Miyahn" <HQF03250@xxxxxxxxxxx> wrote in message
news:e0BMUfoPFHA.1564@xxxxxxxxxxxxxxxxxxxxxxx
> "Rafael T" wrote in message news:uFmeCojPFHA.3076@xxxxxxxxxxxxxxxxxxxx
>> I didn't know that MS script editor existed before, but by seeing this
>> post
>> it got my curiosity.
>>
>> - You said you use Lotus notes objects, ie, etc. How can I add those and
>> others?
>
> You can't add the references on MSE(MS script editor).
> You can add the references for various type-libraries on VBE.
>
> Try my script and select 'Tools'->'References' on VBE menu.
> (I'm not sure English menu expression)
> Open Object Browser(F2), select library, take a look classes and
> members list box.
>
> To add the references by code, change my script as the following.
> ---
> With xlApp.VBE
> On Error Resume Next
> With .ActiveVBProject.References
> 'Reference for Microsoft Internet Controls
> .AddFromGuid "{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}",0, 0
> 'Reference for Lotus Notes Automation Classes
> .AddFromGuid "{1CF542E0-D988-11CF-B485-00805F98FACE}", 0, 0
> ---
>
>> - How do I use early binding or late binding to call intellisense?
>
> To use early binding, declare object variables using 'As' clause.
> Note:
> VBS does not support 'As' clause, so you must remove that
> before execution.
> 'As' clauses are only for editing.
>
> To use late binding, declare object variables without 'As' clause.
> (or do not declare.)
>
> Sample sub procedure, 'As' clauses are commented out.
>
> Sub Test()
> Dim IE 'As InternetExplorer
> Dim nSS 'As NOTESSESSION
> Dim nDb 'As NOTESDATABASE
> Set IE = CreateObject("Internetexplorer.Application")
> IE.VISIBLE = True
> IE.NAVIGATE "About:Blank"
> Set nSS = CreateObject("NOTES.NOTESSESSION")
> Set nDb = nSS.CURRENTDATABASE
> MsgBox nDb.FILENAME
> Set nDb = Nothing: Set nSS = Nothing: Set IE = Nothing
> End Sub
>
> --
> Miyahn (Masataka Miyashita) JPN
> Microsoft MVP for Microsoft Office - Excel(Jan 2005 - Dec 2005)
> HQF03250@xxxxxxxxxxx
>


.

Relevant Pages

  • Re: IDE or Editor for VBS? --Intellisense support
    ... I'm using early binding. ... > You can't add the references on MSE(MS script editor). ... > You can add the references for various type-libraries on VBE. ... declare object variables using 'As' clause. ...
    (microsoft.public.scripting.vbscript)
  • Re: IDE or Editor for VBS?
    ... You can add the references for various type-libraries on VBE. ... 'Reference for Lotus Notes Automation Classes ... > - How do I use early binding or late binding to call intellisense? ... declare object variables using 'As' clause. ...
    (microsoft.public.scripting.vbscript)
  • Re: oracle indexes
    ... Sometimes I will do a query with a where clause that just references ... queries referencing a or a,b or a, b,c. ...
    (comp.databases.oracle.misc)
  • Re: oracle indexes
    ... Sometimes I will do a query with a where clause that just references ... queries referencing a or a,b or a, b,c.  But, I am not as familiar ...
    (comp.databases.oracle.misc)
  • RE: Maintaining Maximum Platform Compatibility
    ... In this case Late Binding is really the only good option. ... Right now I assume you have choosen some references from the Tools -> ... So this would solve compatibility issues: ... Just compile the code with the libraries you need and voila, ...
    (microsoft.public.excel.programming)