Excel Macro Toolbar programming

[Enkrypted]

Is it possible to get a macro to be able to run a button on the toolbar? I have an addin installed, but it needs to be clicked on to run. I was wondering if it is possible to have it run via macro

Enkrypted
A+

 

[mintjulep]

Depending on what you might actually be asking, yes.

 

[Enkrypted]

It's a PDF conversion addin. Here is the link to it

http://www.cib.de/en/products/pdf-products/product-overview/cib-pdf-brewer.html

It says it can support programming, but I want to make sure that I can have like a button that when clicked, will run the addin through a macro or other programming before I actually buy it.

Enkrypted
A+

 

[mintjulep]

Directly from your link

# Generating PDF from within all applications:
The conversion technology used generates PDF documents by choosing "File | Print..." within your applications.
# Buttons in Microsoft© Office (2000 or higher):
From Microsoft© Office 2000 on, Word, Excel and PowerPoint will display buttons for directly calling and configuring the CIB pdf brewer.

 

[Enkrypted]

Yes...there are buttons on the toolbar. I know that. I want to make certain though it can be ran through a macro by clicking on a button in the worksheet, not the toolbar.

Enkrypted
A+

 

[mintjulep]

At the very least you can "print" to it via macro.

 

[Gruuuu]

If you're simply trying to print to a PDF through a macro, have you tried recording a macro while you export a PDF?

 

[Enkrypted]

It's for saving worksheets as a PDF. I've tried recording a macro but it doesn't work.

Enkrypted
A+

 

[Gruuuu]

From my recorded macro:

Sub Macro1()
'
' Macro1 Macro
'

'
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Book2.pdf", Quality:= _
        xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
        OpenAfterPublish:=True
End Sub

That doesn't work?

 

[yooneek]

Try something like this thread707-1640262