Close Adobe Acrobat Opened by Macro

[Michelle72]

Hello,
I have an excel workbook and in it is a macro that takes one of the
sheets and creates a pdf file from it. Once the pdf is created, it is
displayed on screen in the Adobe Acrobat program. Is there a way to
close the Adobe Acrobat program within the macro so when it is finished
I'm back at the worksheet I started in? (the one I ran the macro to
create the pdf in the first place) Any help would be greatly
appreciated.

Thanks!!!!
Michelle

 

[Kevin]

Adobe Acrobat or Distiller has a Check box under preference, enable
to open Acrobat after a PDF has been created. You could just
disable this feature and Acrobat will not open.
good luck!
Kevin Brenner

 

[Michelle72]

Thank you very much Kevin. I didn't realize you could do that and it
worked perfectly.

Thanks again,
Michelle