Converting Excel Worksheets into PDF

[Jonx]

Hello, I have a workbook with about 4 worksheets. I would like t
convert those 4 worksheets into PDF files. Actually, by preference,
would like to put all those worksheets into a single pdf file, but i
this is not possible, 4 separate ones are okay.

Thanks

I apologize, I would like to do this in VB .NET if that is possible.
Or if someone could paste VBA code, I am sure I could figure out how t
convert it.

 

[Frank Kabel]

Hi
if you have a PDF creator program (such as Adobe Acrobat) it will
install a printer driver. Simply send your workbook/worksheets to this
printer

 

[Jonx]

That sounds easy, but where would I find how to print? Or is ther
example code that you could give me to print? A lot of code that
have read recently have always converted from .xls to .ps, and the
from .ps to .pdf rather from .xls straight to pdf. Is there a reaso
for this? Thank

 

[mark kubicki]

how could i automate this process; is this a question that i need to post on
an adobe site, or would you have any idea

Hi
if you have a PDF creator program (such as Adobe Acrobat) it will
install a printer driver. Simply send your workbook/worksheets to this
printer

 

[Tom Ogilvy]

You select the printdriver that generates the PDF as the active printer and
print as normal

Selection.Printout

or
ActiveSheet.Printout

Here is an example post on this topic (using adobe distiller goes to ps
first, then pdf)

http://groups.google.com/[email protected]


Or here are the search results for may postings on the topic:

http://groups.google.com/groups?as_...=microsoft.public.excel.programming&lr=&hl=en

 

[Don]

Try this add-in


http://www.pistulka.com/Excel/index.html