Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a path to a worksheet from outside of excel | Excel Discussion (Misc queries) | |||
Excel worksheet linking | Excel Worksheet Functions | |||
Rename Excel Worksheet | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
create menus in excel worksheet | Excel Worksheet Functions |