manipulating code and adding code to produce pdf

[stevesunfold]

hi guys
does anyone know how i can add this code

Please Login or Register  to view this content.

to this code to get it to save as a pdf?

Please Login or Register  to view this content.

[royUK]

You don't need to use an Excel4 macro.

Please Login or Register  to view this content.

[stevesunfold]

hi roy
i dont really know the difference to be honest thats just what the recorder did.
is there anyway it can be incorporated with the other code?
regards

[stevesunfold]

roy
i currently have this code

Please Login or Register  to view this content.

but it doesnt quite do as i wish
i want it to save the sheet as pdf to the destination shown but not ask me what it needs to be called

[royUK]

I don't have CutePdf installed so I can't test it.

Ken Puls has some sample code for PDF Creator