Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Worksheets into PDF
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Converting Excel to PDF? | Excel Discussion (Misc queries) | |||
Converting worksheets to workbooks. Is there an easy way? | Excel Discussion (Misc queries) | |||
converting workbooks to worksheets | Excel Programming |