Exporting Excel output to pdf/rtf/doc format

S

Simon Lenn

hello All

I have a requirement to export a Excel range in Print format to pdf,
RTF and .doc format can you kindly help me with the sample code on how
to accomplish this.

Many thanks
Simon
 
P

Phil C

Simon

If I understand you correctly, you are needing to export a cell range? The
easiest way would be simple copy/paste (to MS Word) - or multiple
copy/paste - than save the new Word document as .doc or .rtf. For PDF you
would need a third party PDF writer (Adobe's own product, or the excellent
PDF Creator from Jaws systems (www.jawspdf.com). This installs itself as a
printer driver so can 'export' individual sheets (File|Print|Jaws PDF
creator) to a pdf file. As far as I can see, Excel files containing more
than one sheet would have to be exported one at a time, to different files.

HTH, Phil
 
M

Mike A

If you shift-select your worksheet tabs before you print, you can
print several sheets to a PDF using Jaws PDF Creator (or print from
any other printer, for that matter). I use Jaws this way every day to
print multiple sheets to PDF files.

-Mike
Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
M

Mike A

You may want to create a blank Word document with a linked embedded
object of your spreadsheet in it. This will remain up-to-date with
changes you make to your spreadsheet. (You may want to create a new
sheet which references the other data in your workbook to limit the
exported data to the range you mentioned.)

Then, you have your .doc file, Word can create your .rtf file, all you
need is a program to create your .pdf file.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Top