Visio 2003 VBA problem

[Amjad Hussein]

Hi Guys

I have one problem, I have created a VBA code in Excel 2007 to open Visio 2007 and draw a graphics based on the input from excel sheet, and this works fine without any problem.

but when I distributed this to my colleagues in the office, some of them has visio 2003, and this cause a problem.

Now the question is how can I avoid this, I mean what do I need to do in order to make my code which I wrote them for Visio 2007, works for 2003???

Thank you in advance for your help

[NeoPa]

Design your projects in a version that is common to all your users, or maintain two versions.

[Amjad Hussein]

Hi NeoPa

and thank you for your reply, I am really not sure what is the common to all employees, because this project gonna be distributed around all branches in different countries, so it is difficult to know.

I am working now in 3 different version but I thought that may be there is a better solution...

[NeoPa]

If you have 2003 users and 2007 users then a version 2003 database should work pretty well for both in most things.

If you have a large user base that's spread around then that should be one of the first issues you deal with. If this is an afterthought for you, then you will very soon understand why. It's an important consideration for any Access project.