使用Excel 2011中的VBA代码创建PDF [英] Create PDF's with VBA code in Excel 2011
问题描述
大家好
我从Excel 2011开始使用VBA并在我的Mac网站上添加一些示例来创建PDF。
问题  ;:如果您使用VBA SaveAs或将工作簿手册保存为PDF,它将:
为每张工作表创建一个单独的PDF。
此外,它将添加第一个的名称表格到PDF的文件名(错误)
我找到了一个解决方案,请参阅下面的页面。
http://www.rondebruin.nl/mac.htm#PDF
我想知道这是好还是有更好的方法。
我是新用户,所以请跳进去。
我有这个页面用于Excel 2007-2010 for Windows
http://www.rondebruin.nl/pdf.htm
非常感谢
关心Ron de Bruin http://www.rondebruin.nl/tips.htm
<集团kquote>
嗨罗恩,
我在你的网站上看过很多文件,它们对我们很有帮助;)但是,我觉得我不像你提供的那样一些有价值的建议,因为我不熟悉Mac Office和这个论坛,autaully 致力于MS Office。你可能想要在这个特定的论坛上询问它:
http://answers.microsoft.com/en-us/mac/forum/macexcel
感谢您的支持和理解。
祝你好运,
Hi all
I start with VBA in Excel 2011 and add some examples on my Mac site to create PDF's.
Problems : If you use VBA SaveAs or save a workbook manual as PDF it will :
Create a seperate PDF for each sheet.
Also it will add the name of the first sheet to the file name of the PDF(bug)
I have found a solution, see page below.
http://www.rondebruin.nl/mac.htm#PDF
I like to know if this is good or if there is a better way to do it.
I am new Mac user so please jump in.
I have this page for Excel 2007-2010 for Windows
http://www.rondebruin.nl/pdf.htm
Thank you very much
Regards Ron de Bruin http://www.rondebruin.nl/tips.htm
Hi Ron,
I have read a lot of documents in your website, and they are great helpful for us;) However, I think I'm unlike to provide you some valuable suggestions since I'm not familiar with Mac Office and this forum, autaully is dedicate to MS Office. You might want to ask it in this particular forum:
http://answers.microsoft.com/en-us/mac/forum/macexcel
Thanks for your support and understanding.
Good luck,
这篇关于使用Excel 2011中的VBA代码创建PDF的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!