i have a simple excel macro. this is throwing 423 basic runtime error and not running.
Option VBASupport 1
Public Sub printplt1_click()
Dim pdf_template As Worksheet
Set pdf_template = ActiveSheet
Dim wb As Workbook
Set wb = ActiveWorkbook
Dim ws As Worksheet
If Dir(wb.Path & "\" & "export", vbDirectory) = "" Then
MkDir (wb.Path & "\" & "export")
pdf_template.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=wb.Path & "\" & "export" & "\" & "pdf" & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
Steps to Reproduce:
1. save this macro in a file and run macro.
macro should export the sheet as a pdf file.
User Profile Reset: No
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 170014 [details]
423 is method-not-found, and I verified in gdb the method in question is actually ExportAsFixedFormat itself. Object model documentation and OpenGrok concur: it simply isn't implemented.
In my opinion this ticket should be phrased as an enhancement: please implement ExportAsFixedFormat in the object model exposed to macros.
Implementation of this is in progress in (newer) bug 149786.
*** This bug has been marked as a duplicate of bug 149786 ***