Code to Run PDF Maker
I have:
Excel 2003 and Acrobat 7.0 Pro installed on my PC. The Excel file has many worksheets (150+) and many relative hyperlinks. I have 900+ Excel files to convert, so I need an automated solution. I want: Excel VBA code to run the PDF Maker. - I tried printing the file to the Acrobat PDF printer, but this does not convert the bookmarks into hyperlinks. - Using Adobe PDF Convert to Adobe PDF converted the hyperlinks, but this is a manual process I want to automate. - I tried the Excel Create Macro tool to get the code, but it did not record the Adobe PDF menu commands. Any suggestions? |
Code to Run PDF Maker
I found a workaround on the PlanetPDF website. It launches the PDFMaker
button on the PDFMaker 7.0 toolbar. The code for launching the button is: Dim cbar As CommandBar For Each cbar In CommandBars If cbar.Type = msoBarTypeNormal Then If cbar.Name = "PDFMaker 7.0" Then cbar.Controls(1).Execute ' press 1st button on PDFMaker 7.0 toolbar End If End If Next cbar "DevDaniel" wrote: I have: Excel 2003 and Acrobat 7.0 Pro installed on my PC. The Excel file has many worksheets (150+) and many relative hyperlinks. I have 900+ Excel files to convert, so I need an automated solution. I want: Excel VBA code to run the PDF Maker. - I tried printing the file to the Acrobat PDF printer, but this does not convert the bookmarks into hyperlinks. - Using Adobe PDF Convert to Adobe PDF converted the hyperlinks, but this is a manual process I want to automate. - I tried the Excel Create Macro tool to get the code, but it did not record the Adobe PDF menu commands. Any suggestions? |
All times are GMT +1. The time now is 07:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com