Forum Discussion
JMSNYC
7 years agoHelper III
Import files with different files names - Change dynamically files names
Hi, I read some of your solutions to address the changes of files names in PowerBI, but I cannot transpose any of them to my own issues. Could you please help ? 1/ File Name The f...
- 7 years ago
You can leave that as it is. It's just a variable name (now) and has no connection to your actual data.
JMSNYC
7 years agoHelper III
Hi, 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
7 years agoCommunity Champion
You can leave that as it is. It's just a variable name (now) and has no connection to your actual data.