I have a spreadsheet with VBA code that references the Crystal Ball
Developers Kit. (Tools/References in VB). This file is in c:\Program
Files\... in 32bit and of course is in c:\Program Files (x86)\... on my 64
bit system.

How can I use the same spreadsheet on both 32 and 64 bits systems, since
when moving from one system to the other, the addin is missing (it's in the
other directory), and VBA bombs with a compile error.

Can the VBA include a 'dynanmic' reference, that checks the OS, and then
looks in the relevant Program Files folder? If so, how is this done in VBA?

Sounds like you need to look into use late-binding:
http://peltiertech.com/Excel/EarlyLateBinding.html

NickHK

"ralph_y" wrote in message
...
I have a spreadsheet with VBA code that references the Crystal Ball
Developers Kit. (Tools/References in VB). This file is in c:\Program
Files\... in 32bit and of course is in c:\Program Files (x86)\... on my 64
bit system.

How can I use the same spreadsheet on both 32 and 64 bits systems, since
when moving from one system to the other, the addin is missing (it's in
the
other directory), and VBA bombs with a compile error.

Can the VBA include a 'dynanmic' reference, that checks the OS, and then
looks in the relevant Program Files folder? If so, how is this done in
VBA?