I have used the code I found here and tried to extract a PDF file. The code extracts the PDF perfectly in Excel, but I keep getting notification messages. I've disable Display Alerts, but it does not make a difference.
The messages I get are the following:
Is there a way to get rid of the messages?
Selrac10 Life Lessons to Excel in Your 30s. The Most Important Question of Your Life; 7 Strange Questions That Help You Find Your Life Purpose. '3 Ideas to Change.
Selrac2 Answers
jkpietersejkpieterseApplication.DisplayAlerts
refers to the Excel application, not the instance of Word, which is displaying the alerts.
To avoid the first two alerts, use the additional parameters of Documents.Open
- ConfirmConversions - 'True to display the Convert File dialog box if the file isn't in Microsoft Word format' - so
False
. - ReadOnly - 'True to open the document as read-only' - so
True
.
Closing the document without saving changes seems to also avoid the third pop-up. This might be an option as well.
BigBenBigBen