Sharing VBA across multiple platforms (1 Viewer)

[lution]

Currently my access application runs with Office 2007 and expect some of my users to start migrating to Office 2010 after the first of the year. Problem is, I need to support both at the same time. I currently have references to Excel, Word, and Outlook in my VBA.

Anyone have recommendations on how to manage my front-end so it either supports both versions or an easy way to manage everything in a source code control system? I don't want to remember to make every change on two systems to make each package.

Thanks for any info.

 

[ghudson]

I suggest that you research how to use late binding instead of setting version specific references to Excel, Word, etc.