Using External VBA References for 64 and 32 bit XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
VBA?
 
Back
Top