blocks|key|2432743|text|我使用Excel2010时遇到了这个问题。我在Excel的“文件”选项卡的“打印”部分的下拉列表中更改了打印机，从而修复了该问题。我的默认打印机是柯尼卡美能达复印机。我把它改成了本地打印机(实际上并不存在)，它起作用了！现在我有了返回8.5x11+PDF的VBA代码！现在，我不必使用我们笨重的旧笔记本电脑和旧的Office来获得合适的大小。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2432744|请注意，选择Adobe+PDF打印机未解决问题。只需尝试打乱不同的打印机选择，或在您的计算机的设备和打印机中制作一个假打印机并使用它。我希望它适用于其他有同样问题的人！|2432745|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I use Excel 2010 and had this problem. I fixed it by changing the printer in Excel's dropdown list on the Print section of the File tab. My default printer is a Konica Minolta copy machine. I changed it to Local Printer (which doesn't actually exist) and it worked! I now have the VBA code returning an 8.5x11 PDF! Now I don't have to use our clunky old laptop with an old Office to get the right size.

Note that picking the Adobe PDF printer did not fix the problem. Just try messing with the different printer choices, or make a fake printer in your computer's Devices and Printers and use that. I hope it works for others with the same issue!

blocks|key|1833548|text|我也使用Excel2010，也遇到了同样的问题。使用ExportAsFixedFormat时，页面不会缩放。据我所知，这与使用文件类型pdf的另存为是一样的。这意味着您需要缩放工作簿以适应所需的页面。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1833549|如果您：|1833550|-Open打印机设置并选择'No+Scaling‘|1833551|-Page布局>打印区域>清除打印区域|1833552|-Select视图>分页符视图|1833553|它将向您显示页面区域。如果你把你的工作表缩放到这里，它会正确地用ExportAsFixedFormat保存到pdf。|1833554|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

I also use Excel 2010 and had the same problem. When using ExportAsFixedFormat, the page won't scale. From what I understand, it is the same as using the Save As with file type pdf. This means that you need to need to scale your workbook to fit the page that you require.

If you:

-Open printer settings and select 'No Scaling'

-Page Layout > Print Area > Clear Print Area

-Select View > Page Break View

It will show you the page area. If you scale your worksheet to this it will save to pdf using ExportAsFixedFormat properly.

blocks|key|4544829|text|我们遇到了同样的问题，并解决了在设备和打印机上更改默认打印选项的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4544830|-Control面板->设备和打印机->单击选择打印机。|4544831|-Second鼠标按钮->打印机属性->高级->打印默认值->高级。|4544832|-Choose纸张大小，然后单击确定。|4544833|为什么不在excel中改变它呢？因为Excel和运行假脱机的服务之间的权限有关...|4544834|该默认设置可使宏正确地导出为纸张大小。|4544835|如果它对你有效，那要感谢我们的it部门，而不是我:P|4544836|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

We had the same problema and soved it changing at devices and printers the default printing options:

-Control Panel->Devices and Printers->Select the printer by clicking once to it.

-Second mouse button->Printer properties->Advanced->Printing defaults->Advanced.

-Choose paper size and click OK.

Why not to change it at excel? Because somthing related to permissions between Excel and the service running spool or...

That default setting makes the macro to export to the paper size correctly.

If it Works for you, is thanks to our IT department, not to me :P

blocks|key|4544865|text|我将打印区域设置在我想要的位置:+View-Page+Break+Preview。然后File-Print-Scaling+=+Fit+Sheet+on+One+Page或File-Print-Page+Setup-Fit+to:+1页宽x+1高。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4544866|希望这能帮助到别人。|4544867|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I set the print area where I wanted it: View-Page Break Preview.
Then File-Print-Scaling = Fit Sheet on One Page
Or
File-Print-Page Setup-Fit to: 1 pages wide by 1 tall.

Hope it helps someone.

I use Excel 2010 with VBA.

I have the following code :

<pre><code>mySh.PageSetup.PaperSize = xlPaperLetter
mySh.ExportAsFixedFormat Type:=xlTypePDF, _
 Filename:=filePathTmp, _
 Quality:=xlQualityStandard, IncludeDocProperties:=False, _
 IgnorePrintAreas:=False, OpenAfterPublish:=False
</code></pre>

It generates a PDF without error but the size is not correct.
I get a 22.26 x 28.80 cm instead of the 21.59 x 27.94 cm that I would like to obtain.

Any ideas ?

Thanks for your help

wrong PDF output size with ExportAsFixedFormat in Excel VBA

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我使用带有VBA的Excel 2010。我有以下代码：mySh.PageSetup.PaperSize = xlPaperLettermySh.ExportAsFixedFormat Type:=xlTypePDF, _    Filename:=filePathTmp, _    Quality:=xlQuality...

问Excel VBA中使用ExportAsFixedFormat的PDF输出大小错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel VBA中使用ExportAsFixedFormat的PDF输出大小错误EN