Microsoft Office Tutorials and References
In Depth Information
Editing macros
This causes the macro to get the current start date of the active plan for the GIF
image that the macro creates.
6
In the same line, select the date and time “12/4/15 5:00 PM” (including the
quotation marks) that follows ToDate:= and type the following:
ActiveProject.ProjectFinish
Here is the text string you typed
to return the project finish date.
This causes the macro to get the current finish date of the active plan for the GIF
image that the macro creates. Now, if the plan’s start or finish date changes, the date
range used when copying the GIF image will change as well.
Next, you’ll add new macro capabilities while in the VBA Editor.
19
7
Click at the beginning of the line SelectTaskColumn , and press Enter.
8
Click in the new line you just created, press Tab, and type the following:
FilterApply Name:=”Incomplete Tasks”
This line of code will apply the Incomplete Tasks filter to the current view.
9
Click at the beginning of the line ZoomTimescale Reset:=True , and press Enter.
10
Click in the new line you just created, press Tab, and type the following:
FilterClear
This line of code will clear the Incomplete Tasks filter from the current view.
Here are the two lines of text
you added to this macro.
Search JabSto ::




Custom Search