'This macro inserts document properties at the end of the active document. Option Explicit Sub WordMacro () ActiveDocument. InsertParagraphAfter ActiveDocument. InsertAfter 'Name: ' & ActiveDocument. Name ActiveDocument. InsertParagraphAfter ActiveDocument. InsertAfter 'Author: ' & ActiveDocument.
BuiltInDocumentProperties ( WdBuiltInProperty. WdPropertyAuthor ) End Sub Activities [ ] In these activities you will create macros which interact with Word documents. • Document Properties • Create a macro that inserts document information (properties) at the bottom of the active document. There could be several valid approaches to this solution, but one method would be to use the Document Range property. The information listed below is available either as a document property directly, or is included in the BuiltInDocumentProperties. Your macro should include Option Explicit.
But your own productivity is different. Best business productivity apps for mac.
Your inserted information should include the following. • Document Name • Path • Title • Subject • Author • Last Author • Creation Date • Revision Number • Total Editing Time • Number of Paragraphs • Number of Words • Spelling Errors • Grammatical Errors • Custom Footer • Insert a custom footer into the active document. The footer should include the document's full path and filename on the left, and the date the file was last saved on the right. • Custom Footer with Fields • Repeat Activity 2 inserting a custom footer into the active document that includes the document's full path and filename and date the file was last saved. Now implement the macro as an AutoOpen macro, and use Word fields to insert the filename and date last saved.
Question: Q: Office for Mac 2011 - Visual Basic I'm wondering if anyone has suggestions for a good place to get Visual Basic tutorials for Office 2011. I have zero experience in Visual Basic, and limited experience with formulas, tables, lists, and Pivot Tables, so the tutorials should be beginner-friendly. As we continue to improve the overall Visual Basic story on Office 2016 for Mac, we’ve added the following features to Visual Basic Editor: Ability to add modules from within the Project Viewer Ability to add library references using a dialog.
Ensure that the macro tests to see if a footer is already in the document, and does nothing if a footer already exists. See Also [ ] References [ ].
0 kommentar(er)
