[AccessD] Macro Example

If I may chime in.  I think it was SusanH that posted the definition of a
macro according to pcwebopedia that stated "In a way, macros are like simple
programs or batch files. Some applications support sophisticated macros that
even allow you to use variables and flow control structures such as loops."
I think Microsoft has taken the sophisticated macro to an extreme with Word
and Excel macros, nonetheless Microsoft obviously still considers them a
macro since you get to them by going to Tools/Macros.

If I were writing a book about Word or Excel, I would refer to these
procedures as macros.  If I were writing a book about Access, I would point
out the difference betweeen macros and modules.  If I were writing a book
about all three, I would point out the modules in Access use the same VBA as
Word and Excel macros.  It all depends on what application you're talking
about and that particular applications' use of the technology.

just my 2 cents.

RustyH


-----Original Message-----
From: Bryan Carbonnell [mailto:Bryan_Carbonnell at cbc.ca]
Sent: Thursday, April 24, 2003 12:58 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Macro Example


Yea I know. Job security for Softies as someone on another list said today
:-))

But that's why in Word and Excel I don't see there is a difference between a
macro and a procedure. 

Except that hand coded is usually a lot more compact :-))

Bryan Carbonnell
bryan_carbonnell at cbc.ca

>>> Mwp.Reid at Queens-Belfast.AC.UK 24-Apr-03 1:42:46 PM >>>
Come on Bryan we all know Microsoft cant code (<:

Martin


Quoting Bryan Carbonnell <Bryan_Carbonnell at cbc.ca>:

> Same macro Hand coded:
> 
> Sub Test()
> 
> Documents.Open "exam2003.doc"
> 
> End sub
> 
> Bryan Carbonnell
> bryan_carbonnell at cbc.ca 
> 
> >>> Mwp.Reid at Queens-Belfast.AC.UK 24-Apr-03 1:14:03 PM >>>
> Word Macro
> 
> Sub test()
> '
> ' test Macro
> ' Macro recorded 4/24/2003 by mr
> '
>     Documents.Open FileName:="exam2003.doc", ConfirmConversions:=False,
> _
>         ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="",
> _
>         PasswordTemplate:="", Revert:=False, WritePasswordDocument:="",
> _
>         WritePasswordTemplate:="", Format:=wdOpenFormatAuto
> End Sub
> 
> 
> 
> 
> 
> Quoting Nancy Lytle <nancy.lytle at auatac.com>:
> 
> > I would like to have seen an actual example of what a macro is in
> Word
> > or
> > Excel, since I have never used either and have no clue.
> > Nancy L
> > 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John
> Bartow
> > Sent: Thursday, April 24, 2003 12:10 PM
> > To: accessd at databaseadvisors.com 
> > Subject: RE: Hair-Splitting definitions of Macros - was
> > RE:[AccessD]VBAquestion
> > 
> > 
> > It wasn't something important to me but I was enjoying the
> discussion
> > and
> > was looking forward to the eventual decision that might have been
> > arrived
> > at. So I'm asking everyone that was involved to please continue this
> > thread.
> > 
> > Sometimes it nice to just use the delete key rather than the "kill
> > button".
> > I think our moderators come down pretty quickly on inappropriate
> threads
> > and
> > besides, we need to show each other respect on this list and act
> like
> > friends or it will end up like some of the other lists (which I no
> > longer
> > monitor).
> > 
> > It's quite simple, if you want to be a moderator - sign up,
> otherwise
> > don't
> > moderate.
> > 
> > :o)
> > 
> > 
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd 
> > Website: http://www.databaseadvisors.com 
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd 
> > Website: http://www.databaseadvisors.com 
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com 
> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com