Why does the command Publish to Pdf (ExportAsFixedFormat) not work 1

[SeekExcellence]

Hello,

I have the following code for exporting a range as Pdf:

FcFile = Range("FcFile").Value
FileX = ActiveWorkbook.Path & "\" & "Sales" & "\" & FcFile & ".pdf"
Range("Invoice").Select
Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FileX, Quality:= xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=True, OpenAfterPublish:=False

It works fine on one pc, but not on another.
The whole 'Office/Publish' command seems to be desactivated, and I can't get it going.

Any ideas?

Thanks
Seb

 

[TonyJollans]

If you are using 2007, the PDF writer was not built in, but was available as a free download from Microsoft - due to some legal disagreements with Adobe. So, is it possible that the PC it doesn't work on doesn't have the writer installed.


Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[SeekExcellence]

Thanks Tony, That helps understand it.
Any idea where to find the free download that installs the PDF writer?

 

[TonyJollans]

Try:

http://www.microsoft.com/downloads/...11-3e7e-4ae6-b059-a2e79ed87041&displaylang=en

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[SeekExcellence]

Thanks for your help Tony. I will install it and try when I come home.

Just beginning...love to learn from you.
Thanks for replying.