Excel 2010: When I print an excel document using PDF (CutePDF Writer) it automatically offers the Excel folder name as a likely choice as the PDF folder name. When attempting to use XPS Printer (which make a whole lot clearer document) to does not offer me a default folder name (which seems bizarre) and instead asks me to enter a new name every time.
The printing of the document in question is activated by a form button. Is there a way (perhaps some vba code I can add to my "Print" routine?) to get the XPS printer to offer me the Excel folder name as the default?
The printing of the document in question is activated by a form button. Is there a way (perhaps some vba code I can add to my "Print" routine?) to get the XPS printer to offer me the Excel folder name as the default?