ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controlling Acrobat From Excel (https://www.excelbanter.com/excel-programming/339852-controlling-acrobat-excel.html)

Josh Sale

Controlling Acrobat From Excel
 
Does anybody have any VBA examples for writing out the contents of a
workbook to a PDF file using Acrobat? In particular, I want to be
able to specify the targer path and file name.

TIA,

josh





LabElf

Controlling Acrobat From Excel
 
I'm not sure how much control of Acrobat you can get from VBA, but I see in
my VB IDE, under Project / References ... that there are options to select
"Acrobat Access Type 2 Library" and "Adobe SVG Viewer Type Library 2.0". If
you add these references, you might have the tools you need. Use View /
Object Browser to see what methods you have available after adding these
references.
--
In theory, there is no difference between theory and practice; in practice,
there is.


"Josh Sale" wrote:

Does anybody have any VBA examples for writing out the contents of a
workbook to a PDF file using Acrobat? In particular, I want to be
able to specify the targer path and file name.

TIA,

josh







All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com