This content has been marked as final. Show 2 replies
How do you pull in multiple sheets from one excel file when the sheet's are renamed? I know if you have the Sheet's named Sheet1, Sheet 2, etc then you can do something like this. What if you rename the sheets to 2012, 2011, etc? What is the easiest way to import all sheets?
for loop=1 to 5
(ooxml, embedded labels, table is Sheet$(loop));