I'm not sure why nobody responded to this question as it was an easy answer if you know API but thanks to my VAR, CADimension Inc. and Applications Engineer Scott Blackwell, he determined the problem.
Quite simply, the order of references needed to be changed.
With the macro open in Microsft Visual Basic, choose "References..." from the "Tools" drop down menu. From the "Available References" list, I selected "Microsoft Excel 12.0 Object Library" and changed its priority from last to third.
Anyway, that's it.
Life is good, ...again!
Ed there can be several reason for the error and without having the macro it would have been difficult for anyone to reply to it. But glad you got the macro fixed and thanks for sharing the solution.