saving print area as pdf in excel vb macro

[toddioi]

i need a code I can put into one of my macros which will

activate print (the print area has already been set)
save as pdf
name the pdf document the value (or text) of a cell on the worksheet
return to the active worksheet in excel


Right now the macro stops and I have to manually do the above.


Any help out there?

 

[stevexff]

Can you record a macro of your manual actions, and adapt the result for use in your real macro?

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[toddioi]

no. when you step from the excel enviorment to the pdf enviorment this is what you see and does not give much opportunity for modification.

Sub pdf()
'
' pdf Macro
' Macro recorded 10/18/2006 by Trial User
'

'
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub