Excel convert to pdf file in macro

[mond]

Hello everyone
Please help, Is there any chance that a certain excel file can be automatically convert it to printable .pdf file then save it to a folder, say c:/document then replace the old file in macro code, by pressing a command button “convert and save”
Thanks

 

[Stormseed]

Duplicate:

http://www.mrexcel.com/forum/showthread.php?t=381462

 

[ahmedmirza]

I don't know what macro should be used but I suggest you should try the following ...

1. Download cutepdf software. Install it. go to printer settings and choose cutepdf as default printer.

2. Record a macro Tools>Macro>Record new macro (Short cut say ctrl+shift+p). Set print area from each sheet (The way you want to print them). Highlight all the sheet and then print. This will ask you to save as pdf. STOP the macro recorder. Then use the same shortcut (ctrl+shift+p) everytime you want to print.

HDH ...

 

[Joe4]

The other thread was posted just two minutes apart. I suspect that it was an accidental "double-click". Since this one has replies, I have deleted the other one.

If there seems to be a delay when you submit a post, please do not hit Submit again. Usually, that will lead to double-posting.

 

[Venom]

/thank Search
I'm after a similar thing.

I recorded the macro;

Sub Save()
    
    Application.ActivePrinter = "CutePDF Writer on CPW2:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
        "CutePDF Writer on CPW2:", Collate:=True
End Sub

But how do I specify a file path? (G:\[folder]\[folder]\)
I would also like the file name to be YYMMDDhhmm.pdf
Also, would it be possible to paste the "YYMMDDhhmm" value into cell I9?

 

[Venom]

My my, posts run off the pages quickly. =o