Duplicate Save As Dialog - Word To PDF

[bssm]

Hi, I am trying to setup a button, which when clicked brings up the save as dialog box but defaults the file save as type to PDF.

The following is my code:

Please Login or Register  to view this content.

When I run this though what happens is the save as dialog box opens twice. First time it doesn't change the save as type if you then save, it brings up the save as dialog box again this time it does default to PDF?

I can't see how this would happen.

[gmr4evr1]

The .Format = wdFormatPDF is telling it to save as a PDF by default. Could you use this instead of the code you have?

Please Login or Register  to view this content.

This will open the save as dialog window as excel instead of PDF, and allow users to change the name of the file.

[bssm]

I am trying to set it is a PDF by default though. What happens is this though:

Save as Dialog box opens, defaults to word (it is a word document)

Then if you close or save on this dialog box.

It Opens a 2nd save as dialog box, this time with default set to PDF.

I am trying to get rid of the 1st instance of the dialog box.

[gmr4evr1]

My bad, I misunderstood the PDF part. Looking at your code, I don't see why it is opening it twice. I ran it on mine and it only opens the one instance of the save as dialog window, and it is set to save as PDF by default.