Using External VBA References for 64 and 32 bit XP

[ralph_y]

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?

 

[NickHK]

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

NickHK

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?