I have a button for e-mailing a query currently as an Excel spreadsheet however the guy that is using this program much prefers output to PDF without outputting to Excel first and then converting to PDF.
I have setup the button to just export it as a PDF the only problem is the data does not fit on the page because it's defaulting to a portrait layout. Is there an argument or something that I can use in my embedded macro to specify to output in a landscape format?
Thanks.