VBA for print to pdf

**bevc** · 05-31-2016, 02:29 PM

Strangely I actually found this exact question posted on another forum, but the solution didn't work for me.

All I need to do is write some code to print/open a worksheet as a pdf, but NOT to save it - the file will be used by different people on different machines/networks, so the filepath would just cause an error (and I want users to decide for themselves whether to save the report). I recorded a macro and it works with a save. If I remove the filename bit, I get an error saying "not saved" or something.

This is the macro I recorded:

Please Login or Register  to view this content.

Can anyone please tell me how I can remedy this and just open a sheet as a pdf, without saving? Thank you.

**TMS** · 05-31-2016, 03:09 PM

Short story: you can't do what you're trying to do. You can't open a worksheet as a pdf but you can save it.

If the issue is the location where it will be saved, you can use a dialogue box to determine the location: http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm

**TMS** · 06-01-2016, 06:54 AM

Thanks for the rep.

VBA for print to pdf

LinkBack

Thread Tools

Rate This Thread

Display

VBA for print to pdf

Re: VBA for print to pdf

Re: VBA for print to pdf

Thread Information

Users Browsing this Thread

Similar Threads

Print Entire Workbook prints pages out of order and makes several print jobs.

Disabled print toolbar and menu but Print Macro button cannot print also...

Set print area of selected range then print preview if ok then print the document!

Print Macro errors on final print command. Run-time error '1004':

[SOLVED] Print array code for a series of pages that will also determine print area required?

VBA to set print range, open box asking for print qty, print, then redefine print area

[SOLVED] Excel Printing Problem - can't select Print area or Print Titles on Page Set

Bookmarks

Bookmarks

Posting Permissions