Excel Workbooks to PDF part 1000
1 view
Skip to first unread message
p-pdf-general Listmanager
Jun 10, 2005, 6:21:30 AM6/10/05
to
From: "Shannonthomas00" <Shannon...@yahoo.com>
--------- Planet PDF Forum | http://forum.planetpdf.com ----------
Hello,
I have been researching this problem for weeks with no solution.
I have various excel workbooks with multiple tabs (worksheets). Each worksheet must be converted to a singular pdf file with a specific name so they can be batch processed into specifically formatted pdf's.
Please, what is the best approach? Manually distilling these is out of the question. We had some vb code written to open the workbooks and print to distiller. That was back at v5.0, and the macros no longer work. They get hung up at the distiller level.
What is the most efficient way to accomplish my objective?
I read about a distill workbook option. With what software, and would that create seperate pdfs for each tab with a specific name?
Calling all efficiency mavens. Please help.
To reply: mailto:p-pdf-gene...@forum.planetpdf.com
To start a new topic: mailto:p-pdf-...@forum.planetpdf.com
To login: http://forum.planetpdf.com/
To (un)subscribe: mailto:p-pdf-general...@forum.planetpdf.com
--------------------------------------------
Nitro PDF Desktop. PDF for the people. PDF for business.
Now you have a choice! Nitro PDF Desktop is a cost-effective, fully-featured PDF creation and editing tool for everyone.
Buy now for $99.
http://www.nitropdf.com/desktop
--------------------------------------------
--------- Planet PDF Forum | http://forum.planetpdf.com ----------
Hello,
I have been researching this problem for weeks with no solution.
I have various excel workbooks with multiple tabs (worksheets). Each worksheet must be converted to a singular pdf file with a specific name so they can be batch processed into specifically formatted pdf's.
Please, what is the best approach? Manually distilling these is out of the question. We had some vb code written to open the workbooks and print to distiller. That was back at v5.0, and the macros no longer work. They get hung up at the distiller level.
What is the most efficient way to accomplish my objective?
I read about a distill workbook option. With what software, and would that create seperate pdfs for each tab with a specific name?
Calling all efficiency mavens. Please help.
To reply: mailto:p-pdf-gene...@forum.planetpdf.com
To start a new topic: mailto:p-pdf-...@forum.planetpdf.com
To login: http://forum.planetpdf.com/
To (un)subscribe: mailto:p-pdf-general...@forum.planetpdf.com
--------------------------------------------
Nitro PDF Desktop. PDF for the people. PDF for business.
Now you have a choice! Nitro PDF Desktop is a cost-effective, fully-featured PDF creation and editing tool for everyone.
Buy now for $99.
http://www.nitropdf.com/desktop
--------------------------------------------
p-pdf-general Listmanager
Jun 10, 2005, 12:17:19 PM6/10/05
to
From: "LeonardR" <leon...@pdfsages.com>
SDK documentation.
You'd need to take care of the Excel printing stuff yourself.
Leonard
---------------------------------------------------------------------------
Leonard Rosenthol <mailto:leon...@pdfsages.com>
Chief Technical Officer <http://www.pdfsages.com>
PDF Sages, Inc. 215-938-7080 (voice)
215-938-0880 (fax)
At 03:21 AM 6/10/2005, p-pdf-general Listmanager wrote:
>I have various excel workbooks with multiple tabs (worksheets). Each
>worksheet must be converted to a singular pdf file with a specific name so
>they can be batch processed into specifically formatted pdf's.
Acrobat 7 offers an API for automated silent printing. See the
>I have various excel workbooks with multiple tabs (worksheets). Each
>worksheet must be converted to a singular pdf file with a specific name so
>they can be batch processed into specifically formatted pdf's.
SDK documentation.
You'd need to take care of the Excel printing stuff yourself.
Leonard
---------------------------------------------------------------------------
Leonard Rosenthol <mailto:leon...@pdfsages.com>
Chief Technical Officer <http://www.pdfsages.com>
PDF Sages, Inc. 215-938-7080 (voice)
215-938-0880 (fax)
p-pdf-general Listmanager
Jun 16, 2005, 7:37:37 PM6/16/05
to
From: De Siem
Depnding on the layout of the worksheets one way would be to create one pdf of the entire workbook. This is best acomplished by creating a ps file from the excel document and distilling this with distiller. This could be automated with VB either via the distiller API, or using Distiller (pro) watched folders.
Once you have the pdf and assuming one worksheet is one pdf page, you could then extract all pages to individual pdf pages.
Depnding on the layout of the worksheets one way would be to create one pdf of the entire workbook. This is best acomplished by creating a ps file from the excel document and distilling this with distiller. This could be automated with VB either via the distiller API, or using Distiller (pro) watched folders.
Once you have the pdf and assuming one worksheet is one pdf page, you could then extract all pages to individual pdf pages.
Reply all
Reply to author
Forward
0 new messages