I have a button on a form and I want the user to have the ability to select either export to excel or pdf. Where they house it is up to them on their machine. I coded this but it is not working. I get the following error: compile error invalid qualifier.

I need it to be in landscape for orientation when they export because if not then it does not fit the page right in portrait. I also am not entirely sure how to include the graph when it is exported to Excel. In PDF if I simply code this as PDF without the 2 if statements and do this as a simple print job, the graph prints in the pdf just fine but not entirely sure how to export to Excel when you have data and a pivot graph. The graph is a pivot graph and they want to be able to use the functionality of that pivot graph with exported to Excel.

Please Login or Register  to view this content.