I'm posting this again after 9 days because I never got a response the first
time:

With application.dialogs how can I open the "Publish PDF or XPS" dialog box
in Excel 2007? I want the user to be able to choose the file name and folder
for saving a PDF file.