loop through array of text inputs

[TPDave]

Hi All,

I have a workbook with lots of tabs that I'd like to import csv files into. I've got a basic version working (please don't laugh, I know it's not great!) but I'd like to create a loop and make the code simpler if possible.

I presume I need to set up an array of "Resistive 0" "Resistive 6" "Resistive 8" "Resistive 10" "Old 0" "Old 6" "Old 8" "Old 10" "New 0" "New 6" "New 8" "New 10" and then make a loop to cycle through each of the items in the array but I can't figure it out.

Any help would be greatly appreciated! Thanks

[nilem]

Hi TPDave,
maybe this

Please Login or Register  to view this content.

[Norie]

Do you have a list of filenames to import?

[TPDave]

^ The filenames are a variation of the tab names, at the moment we just need the ones here but it might be nice to make something more configurable in future.

Thanks for the solution nilem, it works a treat!