Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 19th 05, 12:58 AM
Rob
 
Posts: n/a
Default 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   Report Post  
Old February 19th 05, 02:53 AM
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Old February 19th 05, 04:48 AM
Rob
 
Posts: n/a
Default

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   Report Post  
Old February 19th 05, 06:07 AM
Myrna Larson
 
Posts: n/a
Default

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   Report Post  
Old February 22nd 05, 10:29 AM
Rob
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel file deleted. Now howdo you delete file NAME NANMAC New Users to Excel 8 September 2nd 05 07:26 AM
Why can I not open an Excel Compound file with Office Excel xp? Wetcoast40 Excel Discussion (Misc queries) 1 February 4th 05 11:42 PM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 09:19 AM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 04:44 AM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 14th 04 12:51 AM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017