1 Reply Latest reply: May 15, 2014 10:15 AM by joey RSS

    Script Post Export Excel Page Orientation

    Dave-G _

      Need a VB.net script to change the Page Orientation from Portrait to Landscape. User wants to open Excel File with out clicking to change the orientation and print. I am not skilled in VB.net and would really appreciate assitance.

        • Script Post Export Excel Page Orientation
          joey

          We have an Access database that is nothing more than vba modules to format spreadsheets.  We call various macros in this dabase from Data Pump in the post export process by calling a batch script.  It's several steps for the first one, but we're pretty familiar with it, and it is working for us. The VBA command to set the page oritentation to landscape is ActiveSheet.PageSetup.Orientation = xlLandscape.