I didn't have Microsoft excel reference library selected . It's all working now. Thanks a million for all your help .