I am trying to write a dt back to an excel file but want to create a file with todays date from template if one does not exist.
I have selected “create if not exists” and indicated the template file but I keep getting the error “QueueItemLogs.xlsx 27\06 does not exist, please check the output path.”
I know the file does not exist because I am trying to create it.
If i understand correctly you are trying to create a excel file with name QueueItemLogs.xlsx 27\06. But if the file name is having \ , it will be considered as folder path, instead of \ in the file name you can try to use like QueueItemLogs_2706.xlsx