[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