How to save selected cells as jpeg or pdf or webpage format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have you looked into Publishing the report?
File>Save As>Web Page.
Then experiment.

Does that help?

***********
Regards,
Ron
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats 2
How can we convert OST to PDF file format? 1
"Save As" to XML file macro using a cell's value 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to save the current worksheet as JPEG, TIFF or DICOM? 2
Adding a fixed date to a cell 2
Spurious Formula Omits Adjacent Cells 2
Spurious Formula Omits Adjacent Cells 1

Back
Top