Hi Firends,
i am trying to export the active sheet in pdf.
below code works fine in exel 2010 but not in excel 2007.
Please suggest me how to export sheet in pdf in excel 2007.Please Login or Register to view this content.
Hi Firends,
i am trying to export the active sheet in pdf.
below code works fine in exel 2010 but not in excel 2007.
Please suggest me how to export sheet in pdf in excel 2007.Please Login or Register to view this content.
Hi,
Simple way how I used to do this - install PDF Creator (or some simillar PDF printer programm), set this PDF printer as Default, configure this PDF creator to automatically save PDF files in some folder and then just use standart "print" options in your code.
Hi Kasan,
thanks for reply.
i have "Dopdf". is it possible in Dopdf?
also i have made a macro in excel 2010 and want to run this macro on another PCs.
some PC have 2007 and some have 2010 excel installed.
In this case how can i set the macro to run on both the PCs
I dont know that is Dopdf and how it works, if its "print in pdf" application - it should work.
About different versions its tricky, best solution would be one code that works on both versions, but if not you can check version of excel before your main code and then run one of two code versions, like
Please Login or Register to view this content.
Hi Kasan,
thanks for the script.
i have install SaveAsPdf add-inns.
now it works in 2007 excel.
You should be able to use Exportasfixedformat in 2007 as long as you have SP2 or later installed. (and if you don't there are so many bugs it's unbelievable)
Rory
And this is the link to SaveAsPDFXPS addin
http://www.mediafire.com/file/pjp8od...dd-In.rar/file
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
thanks YasserKhalil and rorya
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks