I have an excel that has a dynamic name and I would like to open it using the Excel Application Scope. File name is in the format “ABC May 2021 Payroll.xlsx”
Expression is: “C:\Users\do\OneDrive\Current Projects\ABC\Payroll\ABC”+ MonthYear+“Payroll”
I have assigned MonthYear=DateTime.Now.ToString(“MMM yyyy”).
Would appreciate if you can tell me what is wrong.