Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
When i use "Export to Excel" using AJax-Client it exports rows in .xls(97-2003) Format ...
is there a way where we could change this setting to .xlsx or csv format
Thanks
Don't believe you can change the setting but you can have a trigger that runs:
sub ExportCSV
set obj = ActiveDocument.GetSheetObject("CH01")
obj.exportex "Path\FileName.csv", 1
end sub
hth,
Stephen