Do you have a question?

If you are asking is the possible with VBA the answer is Yes.

Maybe this is what you want: Import Data from Microsoft Excel