Drew Wutka
DWUTKA at marlow.com
Fri Apr 25 02:01:15 CDT 2003
I hate to argue semantics with you JC <evilgrin>, but I think macros are still performing the original intent. A macro is a process in which to run automation. It just so happens that to a VB/VBA programmer, macros in Excel and Word are an easy way to run code. Drew > -----Original Message----- > From: John W. Colby [mailto:jcolby at colbyconsulting.com] > Sent: Thursday, April 24, 2003 4:42 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Macro Example > > If I may chime in... > > Macros in Excel CREATE visual basic code. A macro recorder (in the olden > days) was a recording of the keystrokes and mouse clicks that the user > entered. Excel still works that way, but the "macro" is no longer just > the recorded keystrokes, but rather a VB program that represents the > results of those mouse clicks and keystrokes. Thus a macro in Excel isn't > truly a macro in the original sense, but rather a true VB program that > emulates the original intent. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of > rusty.hammond at cpiqpc.com > Sent: Thursday, April 24, 2003 2:31 PM > To: accessd at databaseadvisors.com > Subject: RE: [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 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > ----------------------------------------------------- > eMailBoss puts you in command of your email. > Get your copy today at http://www.eMailBoss.com << File: ATT71825.txt >>