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

If you have Adobe Exchange or Adobe Professional installed - it will
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 select
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 "Send
Fonts" - it is located under one of the "tabs" when you click on
Properties, click OK.
When you are back to the main Print Screen - select PRINT - You will be
asked for a file name and location. The file will default to something
like the following XXXXX.prn.
After the file is printed change the ".prn" to ".ps" double-click on
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 3
letter extension, i.e XXXX.doc for a word document, XXXX.xls for a
excel document.

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


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2297436