This example of running a report and saving it out to a network drive. It changes the format to XLSX first and then saves. - Cacher Snippet

4/28/2014 - 12:52 PM

This example of running a report and saving it out to a network drive. It changes the format to XLSX first and then saves.

This example of running a report and saving it out to a network drive. It changes the format to XLSX first and then saves.

CQ Out XLSX to File

--In the macro
set xls 2007

--in the enquiry

list/domain="ap_invoice_payments_all"/xls="\\fccadc01\FCC-Public$\Finance\Private\Payables Database\CQ Data\AP_PAYMENTS"