ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print To pdf Wait For Save As Completed (https://www.excelbanter.com/excel-programming/427819-print-pdf-wait-save-completed.html)

jutlaux

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.


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com