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.



--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jonx " schrieb im Newsbeitrag
...
Hello, I have a workbook with about 4 worksheets. I would like to
convert those 4 worksheets into PDF files. Actually, by preference,
I
would like to put all those worksheets into a single pdf file, but if
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
to
convert it.




---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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
"Frank Kabel" wrote in message
...
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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jonx " schrieb im Newsbeitrag
...
Hello, I have a workbook with about 4 worksheets. I would like to
convert those 4 worksheets into PDF files. Actually, by preference,
I
would like to put all those worksheets into a single pdf file, but if
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
to
convert it.




---
Message posted from http://www.ExcelForum.com/

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/groups?thre...gp13.phx .gbl


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

http://groups.google.com/groups?as_q...ng&lr= &hl=en

--
Regards,
Tom Ogilvy


"Jonx " wrote in message
...
That sounds easy, but where would I find how to print? Or is there
example code that you could give me to print? A lot of code that I
have read recently have always converted from .xls to .ps, and then
from .ps to .pdf rather from .xls straight to pdf. Is there a reason
for this? Thanks


---
Message posted from http://www.ExcelForum.com/

Try this add-in


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




"Jonx " wrote in message
...
Hello, I have a workbook with about 4 worksheets. I would like to
convert those 4 worksheets into PDF files. Actually, by preference, I
would like to put all those worksheets into a single pdf file, but if
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 to
convert it.




---
Message posted from http://www.ExcelForum.com/