Michael R Mattys
mmattys at rochester.rr.com
Wed Apr 9 13:08:21 CDT 2008
You're welcome, Roz. I hope it helps you. Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: <rosalyn.clarke at barclays.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, April 09, 2008 12:53 PM Subject: Re: [AccessD] Converting macros to VBA code > Thanks Michael. My German isn't great but that's a nice clear bit of > code... > Got sidetracked today but I'll have a crack at this tomorrow. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R > Mattys > Sent: 09 April 2008 14:07 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Converting macros to VBA code > > Another in German: > http://www.team-moeller.de/access/tiptrick/wizhook/savescriptstring.html > > Michael R. Mattys > MapPoint & Access Dev > www.mattysconsulting.com > > ----- Original Message ----- > From: "Michael R Mattys" <mmattys at rochester.rr.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Wednesday, April 09, 2008 8:45 AM > Subject: Re: [AccessD] Converting macros to VBA code > > >> Hi Roz, >> >> Here's an interesting link: >> http://wizhook.web.fc2.com/ >> (Language barrier notwithstanding, it just might help!) >> >> Michael R. Mattys >> MapPoint & Access Dev >> www.mattysconsulting.com >> >> ----- Original Message ----- >> From: <rosalyn.clarke at barclays.com> >> To: <accessd at databaseadvisors.com> >> Sent: Wednesday, April 09, 2008 4:37 AM >> Subject: Re: [AccessD] Converting macros to VBA code >> >> >>> Thanks Michael. >>> >>> I am working with A97 & A2000 databases, converting them all to A2003. >>> >>> The only documentation I've found on WizHook is here: >>> http://www.mdbmakers.com/forums/showthread.php?t=2715&highlight=wizhook >>> >>> Do you (or does anyone) know - is there anything better / more recent? I >>> can't see the function for converting macros in the pdf (though maybe I >>> will >>> see more clearly when I've had some coffee) >>> >>> R >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R >>> Mattys >>> Sent: 08 April 2008 19:58 >>> To: Access Developers discussion and problem solving >>> Subject: Re: [AccessD] Converting macros to VBA code >>> >>> Hi Roz & Group >>> >>> I went over the wizard that I made in 2000. It pulls all of the tables >>> and >>> modules required from the viewable wizards. >>> >>> I believe it will convert any macros from an Access 97 database, but >>> you'll >>> need the WizHook implementation of the same code if you intend to >>> convert >>> (in) A2K or higher macros. >>> >>> Michael R. Mattys >>> MapPoint & Access Dev >>> www.mattysconsulting.com >>> >>> ----- Original Message ----- >>> From: "Michael R Mattys" <mmattys at rochester.rr.com> >>> To: "Access Developers discussion and problem solving" >>> <accessd at databaseadvisors.com> >>> Sent: Tuesday, April 08, 2008 12:37 PM >>> Subject: Re: [AccessD] Converting macros to VBA code >>> >>> >>>> Hi Roz, >>>> >>>> I did make a wizard for this a few years ago, >>>> though I haven't looked at in since then. >>>> >>>> I would work with you to automate the process ... >>>> >>>> Michael R. Mattys >>>> MapPoint & Access Dev >>>> www.mattysconsulting.com >>>> >>>> ----- Original Message ----- >>>> From: <rosalyn.clarke at barclays.com> >>>> To: <accessd at databaseadvisors.com> >>>> Sent: Tuesday, April 08, 2008 9:49 AM >>>> Subject: [AccessD] Converting macros to VBA code >>>> >>>> >>>>> Another automation question; >>>>> >>>>> I am trying to harmonise all these legacy Access databases, and >>>>> several >>>>> of >>>>> them have been built using macros instead of VB code. I know macros >>>>> are >>>>> OK >>>>> and they work perfectly well, but the idea is to make all the databses >>>>> run >>>>> the same way so they have to be converted. However, I don't really >>>>> like >>>>> what >>>>> the wizard does when it converts, and some of these databases have >>>>> hundreds >>>>> of macros. Converting them one at a time is taking hours. >>>>> >>>>> Does anyone know how the wizard does what it does? Is it possible to >>>>> automate >>>>> & customise this process? >>>>> >>>>> TIA >>>>> >>>>> Roz >>>> >>>> -- >>>> 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 >>> >>> This e-mail and any attachments are confidential and intended solely for >>> the addressee and may also be privileged or exempt from disclosure under >>> applicable law. If you are not the addressee, or have received this >>> e-mail >>> in error, please notify the sender immediately, delete it from your >>> system >>> and do not copy, disclose or otherwise act upon any part of this e-mail >>> or >>> its attachments. >>> >>> Internet communications are not guaranteed to be secure or virus-free. >>> The Barclays Group does not accept responsibility for any loss arising >>> from unauthorised access to, or interference with, any Internet >>> communications by any third party, or from the transmission of any >>> viruses. Replies to this e-mail may be monitored by the Barclays Group >>> for >>> operational or business reasons. >>> >>> Any opinion or other information in this e-mail or its attachments that >>> does not relate to the business of the Barclays Group is personal to the >>> sender and is not given or endorsed by the Barclays Group. >>> >>> Barclays Bank PLC.Registered in England and Wales (registered no. >>> 1026167). >>> Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. >>> >>> Barclays Bank PLC is authorised and regulated by the Financial Services >>> Authority. >>> >>> -- >>> 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 > > This e-mail and any attachments are confidential and intended solely for > the addressee and may also be privileged or exempt from disclosure under > applicable law. If you are not the addressee, or have received this e-mail > in error, please notify the sender immediately, delete it from your system > and do not copy, disclose or otherwise act upon any part of this e-mail or > its attachments. > > Internet communications are not guaranteed to be secure or virus-free. > The Barclays Group does not accept responsibility for any loss arising > from unauthorised access to, or interference with, any Internet > communications by any third party, or from the transmission of any > viruses. Replies to this e-mail may be monitored by the Barclays Group for > operational or business reasons. > > Any opinion or other information in this e-mail or its attachments that > does not relate to the business of the Barclays Group is personal to the > sender and is not given or endorsed by the Barclays Group. > > Barclays Bank PLC.Registered in England and Wales (registered no. > 1026167). > Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. > > Barclays Bank PLC is authorised and regulated by the Financial Services > Authority. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >