Okay after some research and a lot of stupidity by myself Ive reached this question, is there a way to use a function that is defined for microsoft excel(ie its in its libray, specifically the analysis toolpack ) and which I can use in the VB editor for Excel to interact with a project im coding in VB6?? If I can how??