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