Code printout

[Vivitech]

I need to be able to compare the code from two versions of my project, to highlight any differences.

With any text-editor-based system, this would be SO easy with a tool like EXAMDIFF, but of course, we have to use the awful VBA code editor, don't we!

I've tried printing the project to file using a generic/text only printer, but VBA insists on putting form feeds and page headers/footers into the output, even in draft mode, and I can't see any way to tell it not to.

Has anybody come up with any neat text-based tools for version control like this?

Am I alone in feeling that life would be so much easier if we could keep our code in external text files and use our favourite text handling utilities to maintain it?

 

[ghudson]

I've tried printing the project to file using a generic/text only printer, but VBA insists on putting form feeds and page headers/footers into the output, even in draft mode, and I can't see any way to tell it not to.

Am I alone in feeling that life would be so much easier if we could keep our code in external text files and use our favourite text handling utilities to maintain it?

Have you tried the Application.SaveAsText method to export your modules as a text file? This thread has the code I have posted to do it. Export All Database Objects Into Text Files

Also, I would not want my code external from my application.

 

[Vivitech]

That's a neat idea - thanks indeed. I'll try it out ASAP.

I can't imagine why you wouldn't want your modules in external files, though! IDE's like the VBA editor are shackles, IMHO. For example, how do you develop an application as a team?

Have you never used programmers text editors such as TextPad, where you can write macros etc. to automate code generation and modification?

I guess I'm showing my age ...!

Thanks again for the idea though - it will work for me, I'm sure.

 

[ghudson]

Source Safe [never used it] is included with the developers edition for Access [called Microsoft Office Developer Extensions for Access 2003] but we rarely have more than one programmer working on the same application at a time.