how to Automatically save a file as PDF (A Docx, for example)

[TassadarExcel]

Hi all,

This is my first message on this community, I'm glad for having register.

I'm trying to add a functionality to a program I've developed using Excel and VBA. I want to be able to open a PDF file and print as PDF in another file, all this automatically.

Now you wonder "Why opening a PDF and save it as PDF?". It is becouse I have PDF files that doesn't work properly on old readers and I solve it by opening them and printing as PDF using CutePDF.

I've read many threads explaining how to save as PDF an spreadsheet but I've no clear how to do this that I need.

Any Help?

Regards

 

[TassadarExcel]

Any advice?

Regards in advance

 

[TassadarExcel]

My last try to this thread

Thanks

 

[Macropod]

What versions of Windows & Office are you using?

 

[TassadarExcel]

Many thanks for your interest, Macropod,

I'm using Office 2016 and Windows 10

Regards

 

[Macropod]

So why not open the PDFs using Word, then use Save As to create the new copies of them?

 

[TassadarExcel]

If I try to open those PDFs using Word a get a message saying something like "This PDF contains interactive features that are not compatible with the PDF distribution. Word will not show this content".

I'm afraid the only solution is opening with adobe reader and print as PDF with cutePDF or another PDF converter.

Many thanks

 

[Macropod]

You might be able to suppress that warning via:
Application.DisplayAlerts = wdAlertsNone
resetting it afterwards to:
Application.DisplayAlerts = wdAlertsAll
The only issue you then need to resolve is whether any content compatible with the earlier readers you're trying to work with is lost.

 

[TassadarExcel]

By opening those files directly with Word (right click, open with Word), if I ignore this message I lose lot of content of the file, so I suppose that calling Word from an Excel macro would give me the same result.

Of couse, as I told, opening those files with Adobe and printing in PDF with CutePDF creates a versión that Works on old Adobe reader versions. Perhaps it could be posible using another PDF writer from CutePDF.

There is a lot of info over the internet explaining how to print as PDF an Excel sheet, the problema is I have to do it with a PDF, hehe.

Regards and thanks again.

 

[TassadarExcel]

I've also found information about take a PDF and automatically print (on a physical printer), I suppose it could work with a PDF printer, but then it surely ask me for every filename to use, and I want to set those filenames via code and do all without user interaction.

Regards