Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-22-2014, 12:01 PM
Hatman58 Hatman58 is offline Macro For Datestamp On ALL Pages Not Working In 2010 Windows 7 64bit Macro For Datestamp On ALL Pages Not Working In 2010 Office 2010 32bit
Novice
Macro For Datestamp On ALL Pages Not Working In 2010
 
Join Date: Aug 2014
Posts: 2
Hatman58 is on a distinguished road
Default Macro For Datestamp On ALL Pages Not Working In 2010

We have a macro that was recorded in PP2003 to update the Master Notes & Notes Pages with a Date & Time stamp in the footer.
Everything worked fine in 2003 but it fails in 2010. It only updates the Master but does not update the Notes.
And we can't record a new macro in 2010 (why would MS remove this feature? )
In any case, following is the VBA which I am not very familiar with at all. Hence the frustration associated with not being able to Record a Macro.


Is there something missing that is needed to be able to update the Master AND the Notes pages?
Thanks for any help on this!
Code:
Sub Footer_Right()
ActiveWindow.ViewType = ppViewNotesMaster
ActivePresentation.NotesMaster.Shapes("Rectangle 7").Select
With ActiveWindow.Selection.ShapeRange
.Fill.Transparency = 0#
.Height = 32
.Width = 300
.Left = 235
.Top = 690
End With
With ActiveWindow.Selection.ShapeRange
.Fill.Transparency = 0#
.Left = 229.5
End With
ActiveWindow.Selection.ShapeRange.Fill.Transparency = 0#
ActivePresentation.NotesMaster.Shapes("Rectangle 7").Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=1, Length:=55).Select
ActiveWindow.Selection.TextRange.Text = ""
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=1, Length:=0).Select
With ActiveWindow.Selection.TextRange
.Text = "Page "
With .Font
.Name = "Arial"
.Size = 11
.Bold = msoFalse
.Italic = msoFalse
.Underline = msoFalse
.Shadow = msoFalse
.Emboss = msoFalse
.BaselineOffset = 0
.AutoRotateNumbers = msoFalse
.Color.RGB = RGB(Red:=88, Green:=48, Blue:=151)
End With
End With
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=6, Length:=0).InsertSlideNumber
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=9, Length:=0).Select
With ActiveWindow.Selection.TextRange
.Text = Chr$(CharCode:=13)
With .Font
.Name = "Arial"
.Size = 11
.Bold = msoFalse
.Italic = msoFalse
.Underline = msoFalse
.Shadow = msoFalse
.Emboss = msoFalse
.BaselineOffset = 0
.AutoRotateNumbers = msoFalse
.Color.RGB = RGB(Red:=88, Green:=48, Blue:=151)
End With
End With
ActiveWindow.Selection.Unselect
ActivePresentation.NotesMaster.Shapes("Rectangle 7").Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=10, Length:=0).Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=27, Length:=0).InsertDateTime DateTimeFormat:=ppDateTimedMMMMyyyy, InsertAsField:=msoFalse
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=43, Length:=0).Select
With ActiveWindow.Selection.TextRange
.Text = " "
With .Font
.Name = "Arial"
.Size = 11
.Bold = msoFalse
.Italic = msoFalse
.Underline = msoFalse
.Shadow = msoFalse
.Emboss = msoFalse
.BaselineOffset = 0
.AutoRotateNumbers = msoFalse
.Color.RGB = RGB(Red:=88, Green:=48, Blue:=151)
End With
End With
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Characters(Start:=45, Length:=0).InsertDateTime DateTimeFormat:=ppDateTimehmmAMPM, InsertAsField:=msoFalse
ActiveWindow.ViewType = ppViewNotesPage
ActiveWindow.ViewType = ppViewNotesPage
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro For Datestamp On ALL Pages Not Working In 2010 Macro to update ole links not working kisa500 PowerPoint 7 02-05-2013 03:52 AM
Word 2010 Page Color not working in macro Sorceress Word 3 10-15-2012 06:02 AM
Macro For Datestamp On ALL Pages Not Working In 2010 Macro for selecting pages and formatting of tables ubns Word VBA 25 08-15-2012 11:48 PM
Macro For Datestamp On ALL Pages Not Working In 2010 Fraction macro not working Ulodesk Word VBA 1 07-18-2012 04:01 PM
Splitting multiple pages using macro F5JASON Excel Programming 0 07-27-2011 08:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft