Why are you so resistant to posting an example Excel file and your code? Couled it be that you are "using" the Forum as a group of unpaid consultants for a project for which you are being paid? We often get "Please do my homework for me", but this is beginning to sound more like "Please do my Job 9without pay, I'll take care of that() for me". I'm sorry to be so cynical, but we are all spinning our wheels speculating about what you are doing and how you are doing it, despite numerous requests for concrete information that, at the very least, would save both you and (more important) us valuable time.
Once more, please post both the data you are trying to read and the code you are hoping to use to read or use it. Please do not waste our time!