My code ran fine when using the .XLS extension (Excel 2003). But with the XLSX extension, if the workbook doesn't exist, I get the usual warning that it does not exist. The code creates the workbook (as it should), but it does not create the specified worksheet and does not export the output. The workbook is created but is empty. Any suggestions (other than manually creating the workbook ahead of time)?
Code: Select all
output export NAME=DQ /CONTENTS EXPORT=VISIBLE LAYERS=PRINTSETTING MODELVIEWS=PRINTSETTING /XLSX DOCUMENTFILE='DQ\MyWorkbook.xlsx' OPERATION=CREATESHEET SHEET=YYstr+Monthstr.