Anyone used ExportAsFixedFormat feature in Excel automation?

pedgaard

Hi guys,

Has anyone been able to use the new feature in Office 2007+ to allow direct save as to .PDF files ?

I can get Word working using a thread on the forum, but in Excel, the command seems more

I have tried these two and both compile, but neither work as i get the standard HRESULT 2147xxxxx error.

xlBook.ExportAsFixedFormat(17,'C:\TEST.pdf',0,TRUE,0,0, FALSE, TRUE);
xlBook.ExportAsFixedFormat(17,'C:\TEST.PDF');

17 should be the PDF format, not sure about the other optional paramters

Kind regards,
pedgaard

pedgaard

Solved it, was the format type !

1 for XPS
0 for PDF

xlBook.ExportAsFixedFormat(0,pFilePath);