Excel To Pdf error

Hi Friends
i am trying to save active worksheet as pdf

But i am getting "Run time error 5 and Invalid procedure call or argument" error message

i get this code on Google search.

please suggest me where i am getting wrong

Please Login or Register  to view this content.

hi friends,
i am using 64 bit pc and excel 2007 so what should i do for pdf add in?

thanks Domski

It runs fine
but the problem is that i can not set the paper size.
if i set the A4 size in worksheet and then run this code
pdf make size "9.24 X 11.96" which is not a A4 size

thanks in advance

Hi Domski

i am making project on my Pc, My pc have Excel 2007
when i run this excel to another pc where xl2003 then it show me error

see below code

Please Login or Register  to view this content.

In xl2003 it show error xlTypePDF "variable not define"

i know SaveAsPDF.exe support only xl 2007.
is there have any exe which support both xl 2003 & 2007.

thanks Domski

but what about setting of paper size A4 in my code
will you help me to set the paper size in A4

thanks in advance