Forum Discussion

ramanr2330's avatar
ramanr2330
Copper Contributor
Aug 06, 2020

Suppressing Office popup when trying to open pdf via excel macros

Hello,

(Not an expert at Excel or VBA, by any stretch, but can muddle my way through)

 

I have to create 1000+ forms for individual users and when opening a PDF using macros, a dialog pops up warning something like

 

"

Opening ABC.pdf

 

Some files can contain viruses ...

 

Would you like to open this file?

"

 

It is annoying to sit click OK every time this shows up. Is there any way to suppress this popup, to automate the file filling/creation?

 

Kinda urgent.

 

Regards

excel
Macros and VBA
office 365

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Aug 07, 2020
    Perhaps try Application.DisplayAlerts=False right before you open the documents.

    Just be sure to turn it back on. Otherwise, it will also suppress the "do you want to save changes" before closing your workbooks, also.

Resources