I pick the file from one folder, run the xls and make some changes then the file is saved in below folder with current Quarter and year under current year and Month with dynamic variables.
“\nlamspntap103.upcit.ds.upc.biz\HQHome$\Jarous\Desktop\Testing RPA\DMR_CHAR”+YearDMR+“”+Datetime.ParseExact(Month,“MMM”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”)+“-”+Month+“\DMR\Templates\Arr\LLG - Arr Template - FY”+YearDMR+" “+Quarter+”.xlsx"
in excel where I have names and emails I am not able to copy the link as is above as it has dynamic variables, so not sure how to do it and attach the file to correct email.
Thank you for your help and advice.