Here's my situation:
I have a folder with 32 indesign files.
I have an excel file with 32 different named data ranges.
The named data ranges match the table size (rows and columns) within each indesign file.
I want to write a script that takes the named data ranges (in alphabetical order) and places them into the corresponding indesign files (alphabetical order).
Are your named ranges placed on various sheets or there is one sheet only?
You have to specify properties:
sheetName or sheetIndex and
just before calling targetTextFrame.place(sourceExcelFile)