You put that expression into the SheetName property, not the Workbook path, right? If so, the sheet name isn’t the issue, the workbook path is. What path are you passing to it?
That would make sense, yeah i’m passing the workbook path through an argument/asset. The workbook path that its going to is a local folder and then \EOD_Report.xlsx.
Should i be naming it differently or doing something differently?
EDIT: Nevermind, small mistake on my end. You were right though, it was an issue with the report path, somehow a quotation mark made its way into the path lol. Thank you SO much @postwick !!!