https://bugs.documentfoundation.org/show_bug.cgi?id=149786
Bug ID: 149786
Summary: VBA ExportAsFixedFormat to Export As PDF
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 181030
--> https://bugs.documentfoundation.org/attachment.cgi?id=181030&action=edit
ExportAsPDF.xls
Please enable VBA compatibility support for Microsoft Excel 2010 VBA code to
export as PDF.
Attached is the MS Excel spreadsheet with the macro:
```
Sub ExportAsPDF()
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=".\ExportAsPDF.pdf", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
```
When the macro code is run with LibreOffice Community 7.3.4.2 an error occurs:
BASIC runtime error
'423'
Property or method not found: ExportAsFixedFormat.
The output `ExportAsPDF.pdf` will be attached in a later as only 1 attachment
is allowed.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
