Hi
are you still using XL2010 ? If not please amend your profile accordingly.
This being said, wouldn't it be easier to achieve using Power Query ? I can't help for the moment, but it's worth looking into.