This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
To do this, I created a slightly different batch macro from my normal recommended approach for loading multiple excel files. I've attached it here.
The key to this modified design is two things:
I used a Dynamic Select tool to deselect all fields after the 15th.
I updated the Properties in the Interface Designer (View->Interface Designer->Wrench icon) to "Auto Configure by Position". This way all of the fields will end up in the same relative positions, regardless of name.