Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print Excel file to PDF
Hi,
Is there a VBA code, or a program whereby I can print an Excel file to a PDF? (Maybe an add-in?) I'd like to do it directly from Excel similarly to the way Word Perfect has that option in the file menu if possible, but anything will be a help. (I'm using Office 2000) Rob |
#2
|
|||
|
|||
Rob
You could purchase Adobe Acrobat. An alternative to buying Adobe Acrobat.... I have had success with the free file downloads and instructions for use here at Dale Nurden's site. http://www.rcis.co.za/dale/info/pdfguide.htm Saves first to single *.ps file which is then converted to *.pdf Returns one PDF file from multiple sheets or selected sheet. Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a separate file for each sheet. Gord Dibben Excel MVP On Sat, 19 Feb 2005 10:58:46 +1100, "Rob" <NA wrote: Hi, Is there a VBA code, or a program whereby I can print an Excel file to a PDF? (Maybe an add-in?) I'd like to do it directly from Excel similarly to the way Word Perfect has that option in the file menu if possible, but anything will be a help. (I'm using Office 2000) Rob |
#3
|
|||
|
|||
Thanks for that Gord, but I may have confused you.
My desire is to be able to firstly, print to Adobe Acrobat via a command in Excel, I would like to incorporate a Print command within some VBA code to find the Adobe Acrobat program so that it saves the Excel worksheet as a PDF. Can this be done using VBA? Secondly, (if Adobe Acrobat is not installed).... I have both Word Perfect and MYOB installed, and both of these programs publish to PDF without having to install Adobe Acrobat, so I thought there might be a way to do this in Excel as well (being a far superior program!) Any ideas? Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Rob You could purchase Adobe Acrobat. An alternative to buying Adobe Acrobat.... I have had success with the free file downloads and instructions for use here at Dale Nurden's site. http://www.rcis.co.za/dale/info/pdfguide.htm Saves first to single *.ps file which is then converted to *.pdf Returns one PDF file from multiple sheets or selected sheet. Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a separate file for each sheet. Gord Dibben Excel MVP On Sat, 19 Feb 2005 10:58:46 +1100, "Rob" <NA wrote: Hi, Is there a VBA code, or a program whereby I can print an Excel file to a PDF? (Maybe an add-in?) I'd like to do it directly from Excel similarly to the way Word Perfect has that option in the file menu if possible, but anything will be a help. (I'm using Office 2000) Rob |
#4
|
|||
|
|||
Excel does not natively create PDF files. You need a 3rd party program such as
Acrobat or one of the cheaper PDF converters. Try searching Google. On Sat, 19 Feb 2005 14:48:09 +1100, "Rob" <NA wrote: Thanks for that Gord, but I may have confused you. My desire is to be able to firstly, print to Adobe Acrobat via a command in Excel, I would like to incorporate a Print command within some VBA code to find the Adobe Acrobat program so that it saves the Excel worksheet as a PDF. Can this be done using VBA? Secondly, (if Adobe Acrobat is not installed).... I have both Word Perfect and MYOB installed, and both of these programs publish to PDF without having to install Adobe Acrobat, so I thought there might be a way to do this in Excel as well (being a far superior program!) Any ideas? Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Rob You could purchase Adobe Acrobat. An alternative to buying Adobe Acrobat.... I have had success with the free file downloads and instructions for use here at Dale Nurden's site. http://www.rcis.co.za/dale/info/pdfguide.htm Saves first to single *.ps file which is then converted to *.pdf Returns one PDF file from multiple sheets or selected sheet. Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a separate file for each sheet. Gord Dibben Excel MVP On Sat, 19 Feb 2005 10:58:46 +1100, "Rob" <NA wrote: Hi, Is there a VBA code, or a program whereby I can print an Excel file to a PDF? (Maybe an add-in?) I'd like to do it directly from Excel similarly to the way Word Perfect has that option in the file menu if possible, but anything will be a help. (I'm using Office 2000) Rob |
#5
|
|||
|
|||
Ok Myrna, I get the point. It seems Excel is lagging behind some programs
generally considered inferior. It seems, in the world where I live and work, PDF format is a vital part and, if Excel (and Word) doesn't include the ability to save files in that format then I believe it needs to consider that in the future to remain competitive. Thanks for your reply. Rob "Myrna Larson" wrote in message ... Excel does not natively create PDF files. You need a 3rd party program such as Acrobat or one of the cheaper PDF converters. Try searching Google. On Sat, 19 Feb 2005 14:48:09 +1100, "Rob" <NA wrote: Thanks for that Gord, but I may have confused you. My desire is to be able to firstly, print to Adobe Acrobat via a command in Excel, I would like to incorporate a Print command within some VBA code to find the Adobe Acrobat program so that it saves the Excel worksheet as a PDF. Can this be done using VBA? Secondly, (if Adobe Acrobat is not installed).... I have both Word Perfect and MYOB installed, and both of these programs publish to PDF without having to install Adobe Acrobat, so I thought there might be a way to do this in Excel as well (being a far superior program!) Any ideas? Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. Rob You could purchase Adobe Acrobat. An alternative to buying Adobe Acrobat.... I have had success with the free file downloads and instructions for use here at Dale Nurden's site. http://www.rcis.co.za/dale/info/pdfguide.htm Saves first to single *.ps file which is then converted to *.pdf Returns one PDF file from multiple sheets or selected sheet. Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a separate file for each sheet. Gord Dibben Excel MVP On Sat, 19 Feb 2005 10:58:46 +1100, "Rob" <NA wrote: Hi, Is there a VBA code, or a program whereby I can print an Excel file to a PDF? (Maybe an add-in?) I'd like to do it directly from Excel similarly to the way Word Perfect has that option in the file menu if possible, but anything will be a help. (I'm using Office 2000) Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel file deleted. Now howdo you delete file NAME | New Users to Excel | |||
Why can I not open an Excel Compound file with Office Excel xp? | Excel Discussion (Misc queries) | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |