Extract Forms, Reports, Modules source code

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Extract Forms, Reports, Modules source code

Post by Pat »

I have been asked to find the differences between a recently developed ADP and a current working MDB version of an application.

Is there a way to extract the VBA code behind the above mentioned objects so i can use a file compare program?

Or is there a better way?

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Extract Forms, Reports, Modules source code

Post by Pat »

I have found a way to do it by looping thru all forms, the reports then modules using:
Application.SaveAsText acForm, "Form name", etc