[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