2007 menu access via vba - acrobat

[cwaidelich]

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Can somebody help me with this?

Thanks in advance.

[royUK]

You don't ned Adobe in Excel 2007, there's a PDF addin that you can download

Excel 2007 does not support ToolBars, the buttons will be in the addins tab

[cwaidelich]

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

[royUK]

Have you found the menu under Addins?

[cwaidelich]

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

[royUK]

It should be there, without seeing the workbook I can't help further

[cwaidelich]

i dont see add in the 2007 menu.

[royUK]

The addin tab should show if you have any addins installed. Try just activating the Analysis ToolPak addin which is usually installed automatically, see this

[cwaidelich]

Hello,

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

i.e: No Addin Tab

[romperstomper]

If you have SP2 installed for Office 2007, then the ability to save as PDF is built-in and does not require an addin. You just need to use the Exportasfixedformat method:

Please Login or Register  to view this content.

for example (from the Help).