Exportasfixedformat Visual Basic. Export asfixed format string wdexportformat boolean wdexportoptimizefor wdexportrange int32 int32 wdexportitem boolean boolean wdexportcreatebookmarks boolean boolean boolean object method. Exportasfixedformat outputfilename exportformat openafterexport optimizefor range from to item includedocprops keepirm createbookmarks docstructuretags bitmapmissingfonts useiso19005 1 fixedformatextclassptr expression an expression that returns a document object.
To specify whether the print areas should or shouldn t be ignored set the ignoreprintareas parameter to true or false as follows. By using the ignoreprintareas parameter of the exportasfixedformat method you can specify whether visual basic for applications should ignore or not the print areas that have been set for the relevant excel file. Exportasfixedformat type filename quality includedocproperties ignoreprintareas from to openafterpublish fixedformatextclassptr expression a variable that represents a workbook object.
Sub setuprangedata rng as range rng formula randbetween 1 100 end sub.
Export asfixed format string wdexportformat boolean wdexportoptimizefor wdexportrange int32 int32 wdexportitem boolean boolean wdexportcreatebookmarks boolean boolean boolean object method. Exportasfixedformat outputfilename exportformat openafterexport optimizefor range from to item includedocprops keepirm createbookmarks docstructuretags bitmapmissingfonts useiso19005 1 fixedformatextclassptr expression an expression that returns a document object. Example the following microsoft visual basic for applications vba macro shows how to use the exportasfixedformat method to save the active publication as a pdf file. Start ms excel 2010.
