Export to different file types (OpenInsight 64-bit) [Revelation On-Line Wiki]

OpenInsight 64-bit, Mihyar Al Masalma, bshumsky, Andrew McAuley

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 10 DEC 2019 01:28:45PM Mihyar Al Masalma wrote:

while trying to export Excel and Word documents to PDF, I ran into an issue using the following code:
x = OleCallMethod(oWorkBook,'SaveAs', PDFFileName, 17)
and had to switch to the following code to get the job done:
x	= OleCallMethod(oDocWo, "ExportAsFixedFormat", destPDFfile, 17, 0, 0, 0)
Our current issue is losing the ability to export Excel Worksheets to HTML since the following code stopped working:
x = OleCallMethod(oWorkBook,'SaveAs', HtmlFileName, 44)
any idea on what should we be looking for?

cheers,

At 11 DEC 2019 03:41PM bshumsky wrote:

while trying to export Excel and Word documents to PDF, I ran into an issue using the following code:
x = OleCallMethod(oWorkBook,'SaveAs', PDFFileName, 17)
and had to switch to the following code to get the job done:
x	= OleCallMethod(oDocWo, "ExportAsFixedFormat", destPDFfile, 17, 0, 0, 0)
Our current issue is losing the ability to export Excel Worksheets to HTML since the following code stopped working:
x = OleCallMethod(oWorkBook,'SaveAs', HtmlFileName, 44)
any idea on what should we be looking for?

cheers,
Hi, Mihyar. I have no idea if this will work, but have you tried changing the HTML export to match the changes you previously had to make for PDF format? That is, change from this:
x = OleCallMethod(oWorkBook,'SaveAs', HtmlFileName, 44)
to this:
x	= OleCallMethod(oDocWo, "ExportAsFixedFormat", HtmlFileName, 44, 0, 0, 0)
- Bryan Shumsky

Revelation Software, Inc.