John Colby
jcolby at colbyconsulting.com
Tue Oct 7 18:34:24 CDT 2003
Well... that runs IF you are in the macro window (command not available otherwise) and converts the SINGLE macro that is currently selected. There are ~50 different macros in the macro window. I am trying to convert ALL of them at once. Sounds like I need to bracket that with code that selects each macro in turn and then runs that line. I was hoping someone had done this already. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, October 07, 2003 2:02 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Converting Macros - Access XP DoCmd.RunCommand acCmdConvertMacrosToVisualBasic Charlotte Foust -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Tuesday, October 07, 2003 9:41 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Converting Macros - Access XP Believe me, I would (If I knew how). John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark Sent: Tuesday, October 07, 2003 9:28 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Converting Macros - Access XP Write a macro? ...sorry couldn't resist;) Mark -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Tuesday, October 07, 2003 3:50 AM To: AccessD Subject: [AccessD] Converting Macros - Access XP I am inheriting an OLD application converted over the years up to AccessXP. It has ~50 macros that in general do nothing other than open forms, reports etc. I thought there was something that would convert ALL the macros to VB at one shot. I can select a SINGLE macro. and the wizard converts that single macro, but I'd prefer to do them all at once. Anyone know how this is done? John W. Colby www.colbyconsulting.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 _______________________________________________ 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