The difference between 2002/XP and windows 7 is the default size of a
memory location. 2002/XP used 32 bit and Windows 7 uses 64 bit. In XP
there was a forlder under windows c:\windows\system32 which had all the
32 bit dynamic libraries. Windows 7 is trying to eliminate the older 32
bit libraries.
I suspect there are ways of turning the older libraries back on. In
the worksheet check that the Analysis Toopak and the Analysis toolpak
VBA are turned on. In VBA make sure these 4 references are enabled in
the VBAmenu Tools - References
1) Visual basic for Applications
2) Microsoft Excel XX.X object library
3) OLE automation
4) Microsoft Office XX.X Object Library
One or more of these libaries may be pointing to the wrong file and you
may have to Browse and find the correct file. You may have additional
referenced library files that also need to be fixed.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=170290
Microsoft Office Help