SeekExcellence
Programmer
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
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