Recently I had to create an Excel spreadsheet export for one of my clients using my Report Generator in Access, it was a thorny project since it wasn’t a straight export from a query or table. I had to instead use vba to create the spreadsheet and place the values of each column and row into each cell.
My client also wanted to have the finished spreadsheet formated to zoom on one page, margins at 0.25 inches and other requirements. I found the link below invaluable, in particular the section on Page Setup.
I highly recommend book marking it! Here it is: