Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PDF Maker Toolbar Buttons | Excel Discussion (Misc queries) | |||
Help Me!!!Excel opening File Maker | Excel Programming | |||
PDF Maker Toolbar | Excel Discussion (Misc queries) | |||
Colo HTML Maker question | Excel Discussion (Misc queries) | |||
Macro - Feeding path and file name to PDF maker | Excel Discussion (Misc queries) |