I use xl2003 and the version of VBA is 6.5. That's the same version of VBA that
xl2007 uses.

I wouldn't worry about the difference between the version numbers of VBA. But
what I would worry about is the code itself. There are things added in each
version that won't work in previous versions.

But that sounds like it's not a problem for you--since you've already tested in
xl2003.

If you can, you may want to try to develop in the oldest versions and then test
in the newer versions--it's usually easier to find the compatibility problems.

Jim Hunt wrote:

I have created a spreadsheet application that I need to distribute. I
originally wrote it using Excel 2007. I then moved it to 2003. Even when
running 2003 on my machine, it is using VBA 6.5. Is there a way to a) force
it to use an older version or b) an easy way (other than upgrading to Office
2007) for an Office 2003 user to load VBA 6.5?

Thanks.

--

Dave Peterson