Hey Guys,
I have about 50 excel where I want to dynamically change the name of the sheet. For example
Input excel sheet name:
1 . Name of the sheet: 010 month end SSM to GL recon Jun 20
2. 011 month end SSM to GL recon Jun 20
3. 012 month end SSM to GL recon Jun 20
4. 019 month end SSM to GL recon Jun 20
Output name: SP010_JUN20_QLIK
SP011_JUN20_QLIK
SP012_JUN20_QLIK
SP019_JUN20_QLIK
Not looking for an entire solution. I am just looking for some sort of guidance. Any help would really appreciative