Hi

I am creating a pdf file from an excel sheet and want to be able to save it without having to click the save dialog box

this is the code i have

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Is there any way I can do this

Thamks