Microsoft Publisher Macros

Popular Posts

• A macro is a series of commands that is recorded so it can be played back (executed) at a later time. Macros are great for reducing the amount of work you have to do on a series of steps that you perform frequently. Here\'s how to create and test a macro in Microsoft Word.

  -->

  Saves a Microsoft Publisher publication in PDF or XPS format. The conversion readies the document to be sent to commercial presses, to copy shops, for desktop printing, or for electronic distribution.

  Syntax

  expression.ExportAsFixedFormat (Format, FileName, Intent, IncludeDocumentProperties, ColorDownsampleTarget, ColorDownsampleThreshold, OneBitDownsampleTarget, OneBitDownsampleThreshold, From, To, Copies, Collate, PrintStyle, DocStructureTags, BitmapMissingFonts, UseISO19005_1, ExternalExporter)

  expression A variable that represents a Document object.

  Msi live update. I just tried it and did not get the error.

  Parameters

  Name	Required/Optional	Data type	Description
  Format	Required	PbFixedFormatType	The format in which you want to export the publication. Can be one of the PbFixedFormatType constants.
  FileName	Required	String	The file name for the exported file.
  Intent	Optional	PbFixedFormatIntent	The output quality of the exported file. Can be one of the PbFixedFormatIntent constants.
  IncludeDocumentProperties	Optional	Boolean	True if you want to save the document properties with the PDF file.
  ColorDownsampleTarget	Optional	Long	The target for down-sampling of colored images. Measured in dots per inch. Must be greater than 96.
  ColorDownsampleThreshold	Optional	Long	The threshold at or above which an image is down-sampled to the ColorDownsampleTarget level.
  OneBitDownsampleTarget	Optional	Long	The target for down-sampling of one-bit images.
  OneBitDownsampleThreshold	Optional	Long	The threshold at or above which an image is down-sampled to the OneBitDownsampleTarget level.
  From	Optional	Long	The page number of the first page to export.
  To	Optional	Long	The page number of the last page to export.
  Copies	Optional	Long	The number of copies.
  Collate	Optional	Boolean	Whether to collate the copies.
  PrintStyle	Optional	PbPrintStyle	The style in which to print the exported file. Can be one of the PbPrintStyle constants. The default value depends on the value of the Intent parameter.
  DocStructureTags	Optional	Boolean	Whether to include document structure tags to improve document accessibility. The default is True.
  BitmapMissingFonts	Optional	Boolean	Whether to include a bitmap of the text. Pass True for this parameter when font licenses do not permit a font to be embedded in the PDF file. If you pass False, the font is referenced, and the viewer\'s computer substitutes an appropriate font if the authored one is not available. Default value is True.
  UseISO19005_1	Optional	Boolean	Whether the resulting document is compliant with ISO 19005-1 (PDF/A). The default is False.
  ExternalExporter	Optional	Variant	A pointer to an add-in that allows calls to an alternate implementation of code. You can add support for additional fixed formats by writing a Microsoft Office add-in that implements the IMsoDocExporter COM interface. For more information, see Extend the fixed-format export feature in Word Automation Services.

  Remarks

  The ExportAsFixedFormat method is the equivalent of the Publish As PDF or XPS command on the File menu in the Publisher user interface.

  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.

  Before running this code, replace pathandfilename.pdf with a valid file name and the path to a folder on your computer where you have permission to save files.

  This software is included for free with every DVR, NVR, IP camera, or security camera system purchase from 123 CCTV. You can connect multiple DVRs, network video recorders and surveillance cameras to easily manage your camera systems.

  Support and feedback

  Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

  The following is a list of Microsoft Office filename extensions, used in Microsoft Officesoftwaresuite as of January 2017.

  Word[edit]

  Legacy

  Legacy filename extensions denote binary Microsoft Word formatting that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Word can still open them, they are no longer developed. Legacy filename extensions include:

  • .doc – Legacy Word document; Microsoft Office refers to them as \'Microsoft Word 97 – 2003 Document\'
  • .dot – Legacy Word templates; officially designated \'Microsoft Word 97 – 2003 Template\'
  • .wbk – Legacy Word document backup; referred as \'Microsoft Word Backup Document\'

  OOXML

  Office Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Word ever since. Pertaining file extensions include:

  • .docx – Word document
  • .docm – Word macro-enabled document; same as docx, but may contain macros and scripts
  • .dotx – Word template
  • .dotm – Word macro-enabled template; same as dotx, but may contain macros and scripts
  • .docb – Word binary document introduced in Microsoft Office 2007

  Excel[edit]

  Legacy

  Legacy filename extensions denote binary Microsoft Excel formats that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Excel can still open them, they are no longer developed. Legacy filename extensions include:

  • .xls – Legacy Excel worksheets; officially designated \'Microsoft Excel 97-2003 Worksheet\'
  • .xlt – Legacy Excel templates; officially designated \'Microsoft Excel 97-2003 Template\'
  • .xlm – Legacy Excel macro

  OOXML

  Office Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Excel ever since. Excel-related file extensions of this format include:

  • .xlsx – Excel workbook
  • .xlsm – Excel macro-enabled workbook; same as xlsx but may contain macros and scripts
  • .xltx – Excel template
  • .xltm – Excel macro-enabled template; same as xltx but may contain macros and scripts

  Other formats

  Microsoft Excel uses dedicated file format that are not part of OOXML and use the following extensions:

  • .xlsb – Excel binary worksheet (BIFF12)
  • .xla – Excel add-in that can contain macros
  • .xlam – Excel macro-enabled add-in
  • .xll – Excel XLL add-in; a form of DLL-based add-in^[1]
  • .xlw – Excel work space; previously known as \'workbook\'

  PowerPoint[edit]

  Legacy

  • .ppt – Legacy PowerPoint presentation
  • .pot – Legacy PowerPoint template
  • .pps – Legacy PowerPoint slideshow

  OOXML

  • .pptx – PowerPoint presentation
  • .pptm – PowerPoint macro-enabled presentation
  • .potx – PowerPoint template
  • .potm – PowerPoint macro-enabled template
  • .ppam – PowerPoint add-in
  • .ppsx – PowerPoint slideshow
  • .ppsm – PowerPoint macro-enabled slideshow
  • .sldx – PowerPoint slide
  • .sldm – PowerPoint macro-enabled slide

  Access[edit]

  Microsoft Access 2007 introduced new file extensions:

  • ACCDB – The file extension for the new Office Access 2007 file format. This takes the place of the MDB file extension.
  • ACCDE – The file extension for Office Access 2007 files that are in \'execute only\' mode. ACCDE files have all Visual Basic for Applications (VBA) source code hidden. A user of an ACCDE file can only execute VBA code, but not view or modify it. ACCDE takes the place of the MDE file extension.
  • ACCDT – The file extension for Access Database Templates.
  • ACCDR – is a new file extension that enables you to open a database in runtime mode. By simply changing a database\'s file extension from .accdb to .accdr, you can create a \'locked-down\' version of your Office Access database. You can change the file extension back to .accdb to restore full functionality.

  Other[edit]

  Publisher[edit]

  • .pub – a Microsoft Publisher publication
  • .xps – a XML-based document format used for printing (on Windows Vista and later) and preserving documents.

  See also[edit]

  External links[edit]

  References[edit]

  
  1. ^\'Excel 2007 XLL Software Development Kit Documentation\'. MSDN. Microsoft. Retrieved 4 June 2013.
  Retrieved from \'https://en.wikipedia.org/w/index.php?title=List_of_Microsoft_Office_filename_extensions&oldid=942682969\'
  ...'>Microsoft Publisher Macros(30.04.2020)

• A macro is a series of commands that is recorded so it can be played back (executed) at a later time. Macros are great for reducing the amount of work you have to do on a series of steps that you perform frequently. Here\'s how to create and test a macro in Microsoft Word.

  -->

  Saves a Microsoft Publisher publication in PDF or XPS format. The conversion readies the document to be sent to commercial presses, to copy shops, for desktop printing, or for electronic distribution.

  Syntax

  expression.ExportAsFixedFormat (Format, FileName, Intent, IncludeDocumentProperties, ColorDownsampleTarget, ColorDownsampleThreshold, OneBitDownsampleTarget, OneBitDownsampleThreshold, From, To, Copies, Collate, PrintStyle, DocStructureTags, BitmapMissingFonts, UseISO19005_1, ExternalExporter)

  expression A variable that represents a Document object.

  Msi live update. I just tried it and did not get the error.

  Parameters

  Name	Required/Optional	Data type	Description
  Format	Required	PbFixedFormatType	The format in which you want to export the publication. Can be one of the PbFixedFormatType constants.
  FileName	Required	String	The file name for the exported file.
  Intent	Optional	PbFixedFormatIntent	The output quality of the exported file. Can be one of the PbFixedFormatIntent constants.
  IncludeDocumentProperties	Optional	Boolean	True if you want to save the document properties with the PDF file.
  ColorDownsampleTarget	Optional	Long	The target for down-sampling of colored images. Measured in dots per inch. Must be greater than 96.
  ColorDownsampleThreshold	Optional	Long	The threshold at or above which an image is down-sampled to the ColorDownsampleTarget level.
  OneBitDownsampleTarget	Optional	Long	The target for down-sampling of one-bit images.
  OneBitDownsampleThreshold	Optional	Long	The threshold at or above which an image is down-sampled to the OneBitDownsampleTarget level.
  From	Optional	Long	The page number of the first page to export.
  To	Optional	Long	The page number of the last page to export.
  Copies	Optional	Long	The number of copies.
  Collate	Optional	Boolean	Whether to collate the copies.
  PrintStyle	Optional	PbPrintStyle	The style in which to print the exported file. Can be one of the PbPrintStyle constants. The default value depends on the value of the Intent parameter.
  DocStructureTags	Optional	Boolean	Whether to include document structure tags to improve document accessibility. The default is True.
  BitmapMissingFonts	Optional	Boolean	Whether to include a bitmap of the text. Pass True for this parameter when font licenses do not permit a font to be embedded in the PDF file. If you pass False, the font is referenced, and the viewer\'s computer substitutes an appropriate font if the authored one is not available. Default value is True.
  UseISO19005_1	Optional	Boolean	Whether the resulting document is compliant with ISO 19005-1 (PDF/A). The default is False.
  ExternalExporter	Optional	Variant	A pointer to an add-in that allows calls to an alternate implementation of code. You can add support for additional fixed formats by writing a Microsoft Office add-in that implements the IMsoDocExporter COM interface. For more information, see Extend the fixed-format export feature in Word Automation Services.

  Remarks

  The ExportAsFixedFormat method is the equivalent of the Publish As PDF or XPS command on the File menu in the Publisher user interface.

  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.

  Before running this code, replace pathandfilename.pdf with a valid file name and the path to a folder on your computer where you have permission to save files.

  This software is included for free with every DVR, NVR, IP camera, or security camera system purchase from 123 CCTV. You can connect multiple DVRs, network video recorders and surveillance cameras to easily manage your camera systems.

  Support and feedback

  Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

  The following is a list of Microsoft Office filename extensions, used in Microsoft Officesoftwaresuite as of January 2017.

  Word[edit]

  Legacy

  Legacy filename extensions denote binary Microsoft Word formatting that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Word can still open them, they are no longer developed. Legacy filename extensions include:

  • .doc – Legacy Word document; Microsoft Office refers to them as \'Microsoft Word 97 – 2003 Document\'
  • .dot – Legacy Word templates; officially designated \'Microsoft Word 97 – 2003 Template\'
  • .wbk – Legacy Word document backup; referred as \'Microsoft Word Backup Document\'

  OOXML

  Office Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Word ever since. Pertaining file extensions include:

  • .docx – Word document
  • .docm – Word macro-enabled document; same as docx, but may contain macros and scripts
  • .dotx – Word template
  • .dotm – Word macro-enabled template; same as dotx, but may contain macros and scripts
  • .docb – Word binary document introduced in Microsoft Office 2007

  Excel[edit]

  Legacy

  Legacy filename extensions denote binary Microsoft Excel formats that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Excel can still open them, they are no longer developed. Legacy filename extensions include:

  • .xls – Legacy Excel worksheets; officially designated \'Microsoft Excel 97-2003 Worksheet\'
  • .xlt – Legacy Excel templates; officially designated \'Microsoft Excel 97-2003 Template\'
  • .xlm – Legacy Excel macro

  OOXML

  Office Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Excel ever since. Excel-related file extensions of this format include:

  • .xlsx – Excel workbook
  • .xlsm – Excel macro-enabled workbook; same as xlsx but may contain macros and scripts
  • .xltx – Excel template
  • .xltm – Excel macro-enabled template; same as xltx but may contain macros and scripts

  Other formats

  Microsoft Excel uses dedicated file format that are not part of OOXML and use the following extensions:

  • .xlsb – Excel binary worksheet (BIFF12)
  • .xla – Excel add-in that can contain macros
  • .xlam – Excel macro-enabled add-in
  • .xll – Excel XLL add-in; a form of DLL-based add-in^[1]
  • .xlw – Excel work space; previously known as \'workbook\'

  PowerPoint[edit]

  Legacy

  • .ppt – Legacy PowerPoint presentation
  • .pot – Legacy PowerPoint template
  • .pps – Legacy PowerPoint slideshow

  OOXML

  • .pptx – PowerPoint presentation
  • .pptm – PowerPoint macro-enabled presentation
  • .potx – PowerPoint template
  • .potm – PowerPoint macro-enabled template
  • .ppam – PowerPoint add-in
  • .ppsx – PowerPoint slideshow
  • .ppsm – PowerPoint macro-enabled slideshow
  • .sldx – PowerPoint slide
  • .sldm – PowerPoint macro-enabled slide

  Access[edit]

  Microsoft Access 2007 introduced new file extensions:

  • ACCDB – The file extension for the new Office Access 2007 file format. This takes the place of the MDB file extension.
  • ACCDE – The file extension for Office Access 2007 files that are in \'execute only\' mode. ACCDE files have all Visual Basic for Applications (VBA) source code hidden. A user of an ACCDE file can only execute VBA code, but not view or modify it. ACCDE takes the place of the MDE file extension.
  • ACCDT – The file extension for Access Database Templates.
  • ACCDR – is a new file extension that enables you to open a database in runtime mode. By simply changing a database\'s file extension from .accdb to .accdr, you can create a \'locked-down\' version of your Office Access database. You can change the file extension back to .accdb to restore full functionality.

  Other[edit]

  Publisher[edit]

  • .pub – a Microsoft Publisher publication
  • .xps – a XML-based document format used for printing (on Windows Vista and later) and preserving documents.

  See also[edit]

  External links[edit]

  References[edit]

  
  1. ^\'Excel 2007 XLL Software Development Kit Documentation\'. MSDN. Microsoft. Retrieved 4 June 2013.
  Retrieved from \'https://en.wikipedia.org/w/index.php?title=List_of_Microsoft_Office_filename_extensions&oldid=942682969\'
  ...'>Microsoft Publisher Macros(30.04.2020)