Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

SeekExcellence

Programmer
Feb 12, 2011
9
BE
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
 
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
 
Thanks Tony, That helps understand it.
Any idea where to find the free download that installs the PDF writer?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top