office 2007 save as pdf

[Raymond Chiu]

Dear all,

I have office 2007 and download save as pdf.
How can I use vb.net to save excel documents in pdf format?

objsheet.saveas ("temp.xls", excel.xlfilefor mat.addin) does not work?????

[Jan Hyde (VB MVP)]

Re: office 2007 save as pdf

"Raymond Chiu" <rchiu5hk@yahoo .com.hk>'s wild thoughts were
released on Wed, 2 Jul 2008 14:24:19 +0800 bearing the
following fruit:

>Dear all,
>
>I have office 2007 and download save as pdf.
>How can I use vb.net to save excel documents in pdf format?
>
>objsheet.savea s("temp.xls", excel.xlfilefor mat.addin) does not work?????

Try this

objsheet.Export AsFixedFormat(X lFixedFormatTyp e.xlTypePDF,
"temp.pdf")
--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde