VBA to select the Width and Height to 1 page , Orientation as Landscape and Paper Size to Legal for multiple xlsx files in a folder

[JBMS]

Hi Team,

Need help with the below query.

VBA to select the Width and Height to 1 page, Orientation as Landscape and Paper Size to Legal for multiple xlsx files in a folder .

Also asked here VBA to select the Width and Height to 1 page , Orientation as Landscape and Paper Size to Legal for multiple xlsx files in a folder - OzGrid Free Excel/VBA Help Forum