Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save selected cells as jpeg or pdf or webpage format? | Excel Discussion (Misc queries) | |||
Format Excel cells | Excel Discussion (Misc queries) | |||
How do I only calculate cells which have a filled color format? | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |