[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: VBA is the core language and spreadsheets



PureBytes Links

Trading Reference Links

Walter:

Hope springs eternal. My guess is that V 7.x will be structurally the same
as the present version. However since they are taking a long time to get
out the new version, its possible that some useful features will be added.

I have tried to use VB and VBA in a simple way with excel.  I found VBA
more difficult than VB.

Somewaht aside from this:  the first general purpost spreadsheet for the
computer was created at the National Bureau of Standards (now called the
National Institute for Standards and Technology)in the 1960's.  It was
called Omnitab.  It allowed fortran routines to be inserted anywhere in the
program.  This made it a very powerful and flexible program.  It was so
easy to use that the manual was little more than a list of commands.  The
program may be available from either the Goverment Printing Office or what
used to be called the Clearinghouse (I'm not sure of the current name.)
There is at least one PC version called Minitab.  It was sold by a company
in State College, PA.

I mention this because the programming methodology that we want in
Metastock was substantially available 35 years ago on mainframes. These had
only a fraction of the computing power of a  PC.  While the Windows
environment adds some  to implementing this, it is not impossible to do.

R4egards

Lionel





----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
Sent: Wednesday, August 25, 1999 8:57 AM
Subject: VBA is the core language


> Thanks for your emails
>
> As far as I understand it, VBA and NOT Visual Basic (VB) is the core
> language for Excel (XL), Word (W) and Visual Basic 6.0 (VB, which is the
> retail stand alone program).
>
> Each application (XL, W and VB) uses different objects, etc. therefore
the
> VBA code looks different for each.
>
> Any custom workbook in XL plus the custom user forms, toolbars, etc.  and
> the underlying VBA code can be inserted as an Add-in into XL for easier
> access and use.
>
> VB stand alone programs can access and use XL workbooks, data and charts
> etc. + any W documents, etc.
>
> VB programs cannot be inserted into XL as an Add-in because VB uses
> different objects than XL.
>
> Ton will have to describe where VBScript fits into this overview.
>
> Maybe Metastock 7.0 will have better linkages so that the Metastock/Excel
> trading package is not quite so "clunky".
>
> Best regards
>
> Walter
>
>