pdfCreator.ActiveSheet.PrintOut copies:=1, ActivePrinter:= _
"PDF Complete on PDFC", collate:=True
How can i add a save location to this code . My default is the desktop when
i save all the the file to be converted my desktop becomes a mess . can anyone
help me how can i save it to a specific location.
PDF Complete is an add on for Office. You'll probably have to check out the documentation on their website. Normally though the printer driver itself should have an option to save the file through the save-as dialog.