In ExcelXP I am trying to produce a single sheet per variable. I currently have the variable as a macro, but only get one tab as the last submitted macro variable. I have seen a few posts, but still cannot get a solution that works. below is the code if anyone has thought, please share.
Hi...I think the issue is that you need to move your file creation option outside of the macro program:
** ONLY have your sheet_name option inside the macro definition;
ods tagsets.excelxp options(sheet_interval='table' sheet_name="&p");