Hi
I use i-logic code set in the template and linked to a Form Button. This code was copied from Curtis Waguespack
blog and lots of hint and tips from this sight. It might work with your workflow,
trigger = iTrigger0
kLandscapePageOrientation = 10242
kPortraitPageOrientation = 10243
If Border = "A4" Then
ThisApplication.ActiveDocument.ActiveSheet.Orientation = kPortraitPageOrientation
ActiveSheet.ChangeSize("A4", MoveBorderItems := True)
ActiveSheet.TitleBlock = "ISD-A4"
ActiveSheet.Border = "Default Border"
ThisApplication.ActiveView.Fit
iLogicVb.UpdateWhenDone=True
ElseIf Border = "A3" Then
ThisApplication.ActiveDocument.ActiveSheet.Orientation = kLandscapePageOrientation
ActiveSheet.ChangeSize("A3", MoveBorderItems := True)
ActiveSheet.TitleBlock = "ISD"
ActiveSheet.Border = "Default Border"
ThisApplication.ActiveView.Fit
iLogicVb.UpdateWhenDone=True
ElseIf Border = "A2" Then
ThisApplication.ActiveDocument.ActiveSheet.Orientation = kLandscapePageOrientation
ActiveSheet.ChangeSize("A2", MoveBorderItems := True)
ActiveSheet.TitleBlock = "ISD"
ActiveSheet.Border = "Default Border"
ThisApplication.ActiveView.Fit
iLogicVb.UpdateWhenDone=True
ElseIf Border = "A1" Then
ThisApplication.ActiveDocument.ActiveSheet.Orientation = kLandscapePageOrientation
ActiveSheet.ChangeSize("A1", MoveBorderItems := True)
ActiveSheet.TitleBlock = "ISD"
ActiveSheet.Border = "Default Border"
ThisApplication.ActiveView.Fit
iLogicVb.UpdateWhenDone=True
ElseIf Border = "A0" Then
ThisApplication.ActiveDocument.ActiveSheet.Orientation = kLandscapePageOrientation
ActiveSheet.ChangeSize("A0", MoveBorderItems := True)
ActiveSheet.TitleBlock = "ISD"
ActiveSheet.Border = "Default Border"
ThisApplication.ActiveView.Fit
iLogicVb.UpdateWhenDone=True
End If
