Forum Discussion
Helper IIIImport files with different files names - Change dynamically files names
You can leave that as it is. It's just a variable name (now) and has no connection to your actual data.
Community ChampionHi JMSNYC,
1) you can simply filter your filenames after a "Begins With"-string:
2) If there's just one sheet in the file, this expression will adress it dynamically, irrespective of its name:
#"Imported Excel"{[Kind="Sheet"]}[Data]
Helper IIIHi, Imke.
Re: issue #1 :
Great suggestion. It works perfectly. Thank you so much. Will post that as a solution.
Re: issue #2 :
There is still a problem in the code:
For whatever reason, row 6 starts with the Sheet Name. Your suggestion helped to replace the "report..." written in red ... but how to avoid for row 6 to start with the Sheet Name ?
Thanks
- ImkeF
You can leave that as it is. It's just a variable name (now) and has no connection to your actual data.