These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Create PDF - but don't open it.

lijon
Registered: Aug 31 2009
Posts: 8

Hi,
I'm running a macro in Excel that turns a spreadsheet into a PDF, fairly straight forward.

Is there a way to stop Adobe from opening and displaying the PDF it creates in Adobe?

Thanks all!

L

My Product Information:
Reader 8.1.4, Windows
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
In the Adobe PDF printer properties menu on the Adobe PDF Settings tab deselect "View Adobe PDF results".

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

lijon
Registered: Aug 31 2009
Posts: 8
Thanks! ...but it doesn't seem to stick (it re-selects the option).

I'm not sure it worked. I ran my excel macro, which PDFs a sheet and saves it, then MOVES it. Even with deselecting "View results", I still get an error msg "Error opening this doc. This file cannot be found." ...as if it's trying to open the file (but can't find it cuz the macro moves it).

Appreciate the input though!
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Is this a specialized macro or just the PDFMaker macro in Excel?

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

lijon
Registered: Aug 31 2009
Posts: 8
specialized. it takes an existing sheet, turns it into a pdf (saves it in c:\) ...then MOVES it to another communal directory (i figure this causes the adobe error ...'file cannot be found', because it's moved!).
Could skip the error altogether if adobe didn't try to open a file (that was no longer there), right?

Thanks again.
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
If this is a specialized macro then the error is probably related to having spaces in the path/filename of the PDF that is passed to Adobe Reader when opening it. If there are spaces in a path/filename, Adobe Reader will not parse it. To correct the problem, the application launching the PDFs need to embed literal double quotes around the path/filename.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

lijon
Registered: Aug 31 2009
Posts: 8
Seems to work for the 1st and 3rd PDF I create.
Sooner or later I'll figure out how to cut the error on the 2nd/middle one too!
Thanks for this.