John W. Colby
jcolby at ColbyConsulting.com
Thu Apr 24 16:42:24 CDT 2003
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 4188 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030424/6e2b0fcd/attachment-0001.bin>