[Mono-list] Am confused.

Talbott Crowell tcrowell@thirdm.com
Tue, 17 Sep 2002 13:01:20 -0400


This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C25E4A.52755FD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

True,
you can use VB6 to invoke Excel components to create Excel documents,
or you can use VBA (inside Excel) to create Excel documents.  VB6
and VBA are the same language, just a different scope (default objects).

You can take VBA code right out of Excel and paste it into VB6.  Once
you add references and fully qualify the object references, the code
basically behaves the same.

-----Original Message-----
From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
Behalf Of Rodrigo Moya
Sent: Tuesday, September 17, 2002 11:44 AM
To: Miguel de Icaza
Cc: Mono List
Subject: Re: [Mono-list] Am confused.


On Tue, 2002-09-17 at 17:18, Miguel de Icaza wrote:
> Hello guys,
> 
>    I am confused about the Basic programming language offerings from
> Microsoft.  So I understand there is VB.NET, and I understand that there
> was an older version of VB called VB6.  Now, what is the deal with VBA?
> 
>    For instance, what is the relationship between Access and Excel and
> all these VB languages?
> 
VBA (Visual Basic for Applications) is a subset of VB available in the
Office applications, used to create macros and modules.

There were also, if I recall correctly, components made available from
the office apps that you could use to create office documents
programatically.

cheers
-- 
Rodrigo Moya <rodrigo@ximian.com>


_______________________________________________
Mono-list maillist  -  Mono-list@ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list


------=_NextPart_000_000C_01C25E4A.52755FD0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DWindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.6249.1">
<TITLE>RE: [Mono-list] Am confused.</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>True,</FONT>

<BR><FONT SIZE=3D2>you can use VB6 to invoke Excel components to create =
Excel documents,</FONT>

<BR><FONT SIZE=3D2>or you can use VBA (inside Excel) to create Excel =
documents.&nbsp; VB6</FONT>

<BR><FONT SIZE=3D2>and VBA are the same language, just a different scope =
(default objects).</FONT>
</P>

<P><FONT SIZE=3D2>You can take VBA code right out of Excel and paste it =
into VB6.&nbsp; Once</FONT>

<BR><FONT SIZE=3D2>you add references and fully qualify the object =
references, the code</FONT>

<BR><FONT SIZE=3D2>basically behaves the same.</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>

<BR><FONT SIZE=3D2>From: mono-list-admin@ximian.com [<A =
HREF=3D"mailto:mono-list-admin@ximian.com">mailto:mono-list-admin@ximian.=
com</A>]On</FONT>

<BR><FONT SIZE=3D2>Behalf Of Rodrigo Moya</FONT>

<BR><FONT SIZE=3D2>Sent: Tuesday, September 17, 2002 11:44 AM</FONT>

<BR><FONT SIZE=3D2>To: Miguel de Icaza</FONT>

<BR><FONT SIZE=3D2>Cc: Mono List</FONT>

<BR><FONT SIZE=3D2>Subject: Re: [Mono-list] Am confused.</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>On Tue, 2002-09-17 at 17:18, Miguel de Icaza =
wrote:</FONT>

<BR><FONT SIZE=3D2>&gt; Hello guys,</FONT>

<BR><FONT SIZE=3D2>&gt; </FONT>

<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp; I am confused about the Basic =
programming language offerings from</FONT>

<BR><FONT SIZE=3D2>&gt; Microsoft.&nbsp; So I understand there is =
VB.NET, and I understand that there</FONT>

<BR><FONT SIZE=3D2>&gt; was an older version of VB called VB6.&nbsp; =
Now, what is the deal with VBA?</FONT>

<BR><FONT SIZE=3D2>&gt; </FONT>

<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp; For instance, what is the =
relationship between Access and Excel and</FONT>

<BR><FONT SIZE=3D2>&gt; all these VB languages?</FONT>

<BR><FONT SIZE=3D2>&gt; </FONT>

<BR><FONT SIZE=3D2>VBA (Visual Basic for Applications) is a subset of VB =
available in the</FONT>

<BR><FONT SIZE=3D2>Office applications, used to create macros and =
modules.</FONT>
</P>

<P><FONT SIZE=3D2>There were also, if I recall correctly, components =
made available from</FONT>

<BR><FONT SIZE=3D2>the office apps that you could use to create office =
documents</FONT>

<BR><FONT SIZE=3D2>programatically.</FONT>
</P>

<P><FONT SIZE=3D2>cheers</FONT>

<BR><FONT SIZE=3D2>-- </FONT>

<BR><FONT SIZE=3D2>Rodrigo Moya &lt;rodrigo@ximian.com&gt;</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>_______________________________________________</FONT>

<BR><FONT SIZE=3D2>Mono-list maillist&nbsp; -&nbsp; =
Mono-list@ximian.com</FONT>

<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.ximian.com/mailman/listinfo/mono-list">http://lists.=
ximian.com/mailman/listinfo/mono-list</A></FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_000C_01C25E4A.52755FD0--