3 Questions That Will Change Your Life Pdf To Excel

3 Questions That Will Change Your Life Pdf To Excel

Active12 months ago

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?

Selrac

10 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.

One word that will change your lifeSelrac
1,0134 gold badges23 silver badges56 bronze badges

2 Answers

jkpietersejkpieterse
2,2551 gold badge4 silver badges15 bronze badges

Application.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.

BigBen3 questions that will change your life pdf to excel freeBigBen
10.3k3 gold badges9 silver badges25 bronze badges

3 Questions That Will Change Your Life Pdf To Excel Free

Not the answer you're looking for? Browse other questions tagged excelpdf or ask your own question.