[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