[AccessD] Converting macros to VBA code

Hi Michael

It claims to do so, but I have never tried it. I wouldn't be too optimistic, but given the task of Roz it could be worth the effort to check it out.

/gustav

>>> mmattys at rochester.rr.com 08-04-2008 19:06 >>>
Hi Gustav,

Does it convert macros?
I've never tried it, have you?

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com 

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, April 08, 2008 12:51 PM
Subject: Re: [AccessD] Converting macros to VBA code


> Hi Roz and Michael
>
> How about the converter here:
>
> http://www.iriesoftware.com/ 
>
> /gustav
>
>>>> mmattys at rochester.rr.com 08-04-2008 18:37 >>>
> 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