Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu

D

DORI

I have several spreedsheets that users enter some data and then the results
appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on (let say)
an
actionbutton on the "Report" sheet to automatically save the cells A1:N28 as
JPEG or PDF or TIFF formats in a folder called "OB Reports"? I also have some
"objects" and "check boxes" located on top of cells A1:N28.
I understand that the VBA is the way to do it but I am new to VBA. Could any
of those genii out there help me with some simple instructions how to do this?
Thank you so much in advance.
Dori
 
W

wjohnson

If you have Adobe Exchange or Adobe Professional installed - it wil
usually put an icon on the menu bar which says convert to PDF.
This will convert the whole sheet or report.
If you just want to have the rows and columns you select - then selec
your columns and rows. Go to Print - then select "Print Selection"
then select "Print to File." Then in the Printer selection box
Select Acrobat Distiller - then click on "Properties" - Select "Sen
Fonts" - it is located under one of the "tabs" when you click o
Properties, click OK.
When you are back to the main Print Screen - select PRINT - You will b
asked for a file name and location. The file will default to somethin
like the following XXXXX.prn.
After the file is printed change the ".prn" to ".ps" double-click o
the file icon and it should convert automatically to PDF.
You cannot do this with Acrobat reader.
You will also have to configure your machine so you can see the
letter extension, i.e XXXX.doc for a word document, XXXX.xls for
excel document.

The other solution is to save the whole sheet as pdf - then open it an
delete the pages you do not want to send and then "crop out" what you d
not want to send on the single page.
Sometimes only procedure gives better results that the other, i
convert directly from Excel or save as a file and then convert
 
Top