Re: VB and VBscript - Difference


"mike williams" <mike@xxxxxxxxxxxxxxxxx> wrote in message
news:ePAt7Gr8FHA.3388@xxxxxxxxxxxxxxxxxxxxxxx
> "Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
> news:Vs-dnWscdKkcDhXeRVn-iQ@xxxxxxxxxxxxxxx
>
> > VBScript is essentially a deliberately stripped down VBA, it doesn't
> > support OLE automation, (except for server-side VBScript where
> > VBScript is actually VBA running within an ASP host container)
>
> Oh. Right. Does that mean it can actually bake the bread, or can it just
> toast it, like Mayayana said?
>
> Mike
>
>
>
>
>
> . VBScript runs has a separate
> > interpreted component, which shares syntax and not much else with
VBA/VB.
> It
> > has a limited number of datatypes for example, and knows little about
its
> > environment or container (no default references or inheritance for
> example).
> >
> > hth
> > -ralph
> >


An interesting question.

Any discussion of 'VBScript', 'VBA', or 'VB' comes down to context and usage
with a great deal of co-mingling and is probably why there isn't a
definitive answer only explanations of the differences in fundamental
characteristics.

Mayayana's suggestion that they differ by limitation is perhaps as adequate
as any.

-ralph


.

Relevant Pages

  • Re: Use VBA to open Windows Explorer to a particular folder
    ... Import the VBScript into your VBA code. ... Use the ShellExecute API to call the VBScript. ... Alias "ShellExecuteA" (ByVal hWnd As Long, _ ByVal lpOperation As String, _ ... Run the macro. ...
    (microsoft.public.word.vba.beginners)
  • Re: add Excel worksheet problem
    ... You have to rely on the VBA documentation that comes with Office apps. ... Automating Office applications externally via VBScript (or any other COM ... capable language) starts by creating a reference to the specific Office ... application while performing a task that they want to automate and then ...
    (microsoft.public.scripting.jscript)
  • Re: Ping Steve Yandl or other VBScript gurus
    ... post on the vbscript newsgroup and that got me going in the right direction. ... 'Run macro named createResumeFromFile, which has no arguments, and catch its ... 'Exit the script with the value of the return code from the macro/function. ... how to do what I want to do entirely in VBA or VBScript; ...
    (microsoft.public.word.vba.general)
  • Re: Insert image to Excel programmatically
    ... If multiple pictures are going to be inserted ... Use the temp macro as a guide to create the VBScript ... > Your best bet is to then refer to the Office VBA documentation... ... > application while performing a task that they want to automate and then ...
    (microsoft.public.scripting.vbscript)
  • Re: Word.Document, wdGoToBookmark, Bad parameter error
    ... > objects and methods with VBScript instead of with VBA or macros? ... Your best bet is to then refer to the Office VBA documentation... ... Basic Reference/Visual Basic Reference. ... application while performing a task that they want to automate and then ...
    (microsoft.public.scripting.wsh)