Shortcut Icons

[Souwalker]

Hi
Am trialling the creater. Notice, like Adobe PDF converter, their is a Foxit Convert To PDF icon in Miscrosoft Word. That's great. I can't seem to see or add on in MS Excel. Is there a solution?
Thanks
Pat

[Andy]

You can assign something like this to a button:

Sub PrintFoxitPDF()
    Application.ActivePrinter = "Foxit PDF Printer on Ne01:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
   
    Application.ActivePrinter = "Dell Laser Printer P1500 on Ne03:"
End Sub

For me, this prints to the Foxit PDF Printer and then returns the active printer to my laser printer, so the next time I click the regular print button it goes to the printer.

To figure out exactly what you should put it, just record a macro where you print to the pdf printer and then re-select your regular printer.

[Souwalker]

Thanks
Wont it be simpler for Foxit to add the feature similar to what they have in Word, to Excel, at installation? Or add-in via Excel's Add-in feature?
Rgds
Pat

[Andy]

Sure, that would be easier, but do you want a button today? ;)

Plus it needs to be done better than the toolbar in Word, which is impossible to get rid of without changing the registry or deleting/renaming the .dll.