excel 2003 macro that use acrobat Elements
 

Hi,
I am trying to save excel sheets as pdf with a macro that usies excel 2000-3
and acrobat 7.0 elements.
It all works fine if I do manual input of the filename in the print window.
But I don't know how can I pass to acrobat elements the file name through
VB. Infact if I specify filename in the PrintOut method, this name is not
passed to acrobat elements, but used for postscript out.
Is there someone that can say me how can I implement filename passing in VB?
Thanks,
Renato

excel 2003 macro that use acrobat Elements
 

Hi,
can I pass filename through the registers?
Renato

"Renato" wrote:

Hi,
I am trying to save excel sheets as pdf with a macro that usies excel 2000-3
and acrobat 7.0 elements.
It all works fine if I do manual input of the filename in the print window.
But I don't know how can I pass to acrobat elements the file name through
VB. Infact if I specify filename in the PrintOut method, this name is not
passed to acrobat elements, but used for postscript out.
Is there someone that can say me how can I implement filename passing in VB?
Thanks,
Renato