Thread: 2007 menu access via vba - acrobat

Hello there,

we created a very cool excel sheet here at the office for the boss, with several info he needs. We want to create a pdf from this excel, but wait! it has to be via de Pdf Button at the menu and not the "Adobe PDF" Printer, because the document contains links in the worksheets that have to keep on working as pdf.

In Excel 2003 i managed to get to work it like this:

Sub Botón1_AlHacerClic()

    Dim cbar As CommandBar
    Dim i
    
    For Each cbar In Application.CommandBars
        
        If cbar.Type = msoBarTypeNormal Then
            If cbar.Name = "Acrobat PDFMaker 9.0" Then
                
                Sheets(Array("Hoja2", "Hoja3")).Select
                cbar.Controls(1).Execute
           
            End If
        End If

    Next cbar


End Sub

But the Excel has to work in 2007 and when i do something like the following:

Sub Botón2_AlHacerClic()

    Dim cbar As CommandBar
    Dim i
    
    For Each cbar In Application.CommandBars
         Range("A1").Offset(i,0).value = cbar.name
         i = i + 1
    Next cbar


End Sub

in 2003 I find "Acrobat*" but in 2007 nothing shows up.

Can somebody help me with this?

Thanks in advance.

Hi, thanks to the advice. But we are not allowed to install any software at the office, so sadly this does not work for me.

Christian

nope...........

i dont see add in the 2007 menu.

Hello,

ok i installd the "Addon" but to be honest i don't find any diference in the worksheet.

i.e: No Addin Tab