Paul Watkins wrote:
Hi
I have an excel sheet which i would like to convert to pdf via vb automatic
code.

What i want to do is click a button - run a macro that would convert the
sheet to PDF.
I recorded a macro when doing this manually, but when i run the code i
cannot get passed the save as dialog box.

Is there any code to do this?


Thanks in advance


Paul


------------------------------

I'm not sure what you want to do, but what I have done is to install
PDF995. It's a free program on the web that acts like a printer driver.
You tell Excel (or any other program) to print what you want, and then
select PDF995 as the printer to send it to and it creates a PDF file
that's an image of what you selected to print.

Bill