View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jutlaux jutlaux is offline
external usenet poster
 
Posts: 22
Default Print To pdf Wait For Save As Completed

I am CutePDF Writer to convert a excel sheet to a pdf via a macro.

I have 2 questions:
1) How can I have my code wait after the print command for the user to
select a Save As location and hit the Save As button or hits the cancel
button on the Save As popup.
2) From the Save As popup how can I capture if "Save As" was hit vs "Cancel"?

In my current environment I am not able to add any add-ins to complete this.