Nancy Lytle
nancy.lytle at auatac.com
Thu Apr 24 12:28:44 CDT 2003
Thanks, I went to word, opened the VBE and added the code (changing the path and file name), saved the doc, went to Tools>Macros and there it was, I hit run and the doc opened in a new window. A miracle, I say! Is it too obvious I don't use Word that much:)) So I put it in the same way I would in Access, but the way Word handles it is like Access handles a macro, a simple choice for the user, run or not run. Nancy L -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mwp.Reid at Queens-Belfast.AC.UK Sent: Thursday, April 24, 2003 1:14 PM To: accessd at databaseadvisors.com Subject: [AccessD] Macro Example 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