I have a macro which opens a workbook, runs a query, copies the data to a new workbook and then emails this new workbook before closing the original workbook.
However when I attempt to perform page setup in the macro on the newly created workbook (to fit to 1 page and make landscape) the settings are lost when the sheet is emailed and it reverts to 100% and portrait.
Does anyone know a way around this.
Thanks,
CAB
However when I attempt to perform page setup in the macro on the newly created workbook (to fit to 1 page and make landscape) the settings are lost when the sheet is emailed and it reverts to 100% and portrait.
Does anyone know a way around this.
Thanks,
CAB