Member Avatar for imBaCodes

I have this code.

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.

thank you!!

  • 2 Contributors
  • 4 Replies
  • 295 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by imBaCodes
Member Avatar for tinstaafl

Is the pdf printer driver for saving files or printing? What library are you using for pdf's? What pdf printer driver are you using?

Edited by tinstaafl
Member Avatar for imBaCodes

PDF Complete . thats what im using its built in on my 2003 excel .. and im using it for printing an excel sheet to pdf.

Member Avatar for tinstaafl

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.

Edited by tinstaafl
Member Avatar for imBaCodes

Thanks guyss for all the help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.