You can include the standard file name extension for the output format you select with the Output Format argument, but it is not required. The file to which you want to output the data, including the full path. For more information, see Save or convert to PDF or XPS. Note: You can export to a PDF or XPS format file from Office Access 2007 only after you install the add-in. If you leave this argument blank, Access prompts you for the output format. You can select Excel 97 - Excel 2003 Workbook (*.xls), Excel Binary Workbook (*.xlsb), Excel Workbook (*.xlsx), HTML (*.htm *.html), Microsoft Excel 5.0/95 Workbook (*.xls), PDF Format (*.pdf), Rich Text Format (*.rtf), Text Files (*.txt), or XPS Format (*.xps). The type of format you want to use to output the data. If you run a macro containing the ExportWithFormatting action in a library database, Access first looks for the object with this name in the library database, and then in the current database. The Object Name box shows all objects in the database of the type selected by the Object Type argument. The name of the object containing the data to output. If you want to output the active object, select its type with this argument, but leave the Object Name argument blank. Click Table (for a table datasheet), Query (for a query datasheet), Form (for a form or form datasheet), Report, Module, Server View, Stored Procedure, or Function in the Object Type box in the Action Arguments section of the macro design window. The type of object containing the data to output. The ExportWithFormatting action has the following arguments. Note: The ExportWithFormatting macro action is not available in Access web apps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |