If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to save selected cells as jpeg or pdf or webpage format?
I have several spreedsheets that I enter some data and then the results
appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on an actionbutton on the "Report" sheet to automatically save the cells A1:N28 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
|
|||
|
|||
How to save selected cells as jpeg or pdf or webpage format?
Have you looked into Publishing the report?
FileSave AsWeb Page. Then experiment. Does that help? *********** Regards, Ron "DORI" wrote: I have several spreedsheets that I enter some data and then the results appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on an actionbutton on the "Report" sheet to automatically save the cells A1:N28 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 |
#3
|
|||
|
|||
How to save selected cells as jpeg or pdf or webpage format?
Thanks Ron,
I want to save it from within the worksheet rather than going to file/save/as etc. as the users are not familiar with these steps and would make it too confusing for them. In addition, I need to know if there is a VBA code to save the worksheet as JPEG or PDF directly from the worksheet. Dori "Ron Coderre" wrote: Have you looked into Publishing the report? FileSave AsWeb Page. Then experiment. Does that help? *********** Regards, Ron "DORI" wrote: I have several spreedsheets that I enter some data and then the results appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on an actionbutton on the "Report" sheet to automatically save the cells A1:N28 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i change settings to save as jpeg | Carlos | General Discussions | 2 | May 3rd, 2005 10:39 PM |
How do I save an image that's a gif but the save as choice is | cmarvel41 | General Discussion | 1 | April 16th, 2005 10:19 PM |
save as default file format | robDotCalm | General Discussion | 3 | January 29th, 2005 10:56 PM |
Format will not save! | Fred | General Discussion | 2 | June 15th, 2004 06:02 PM |
How to Save in V2000 Format | Steve | Visio | 1 | June 2nd, 2004 07:57 AM |