将Excel范围另存为pdf [英] Save Excel range as pdf

问题描述

我想将特定的工作表或特定的范围另存为" pdf.

I'd like to 'save as' a specific sheet or specific range to pdf.

我尝试在代码中实现范围.

I tried implementing a range into my code.

这就是我一直在努力的事情:

Here is what I've been working with:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
  "c:\Book1.pdf", Quality:= _
  xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
  OpenAfterPublish:=True

推荐答案

您有代码，只需使用范围而不是activesheet

you have the code, just use a range instead of activesheet

例如Sheets("Sheet1").Range("B2:H28").ExportAsFixedFormat ...

这篇关于将Excel范围另存为pdf的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！