View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
SA SA is offline
external usenet poster
 
Posts: 5
Default .xls values, like .pdf

Antonio:

1.) If you stop by our web and look in the MS Excel developer tools area, we
have a small add in called "copy sheet" with which from a menu, you can copy
a sheet (that contains formulas, calcs etc.) to a new worksheet which
contains just the values from the file, so that the user doesn't have to
have all the data.

2.) We also have another Add In that is a PDF Wizard for Excel, which if you
have any one of 10 different PDF printer drivers on your machine, (some of
which are very in-expensive) you can one click output the Worksheet or
Workbook to a PDF file (and merge it with Word docs or other PDF files).

Hope that helps
--
SA
ACG Soft
http://www.groupacg.com

"Antonio" wrote in message
...
What is the easiest way to make a copy of a workbook where the cells
contain
only the values and the formatting?

No formulas behind, if possible no VBA code etc.

Similar to pdf, it is like taking a picture of the different worksheets so
that they can be viewed by others. (I believe that Microsoft came very
close
to saving as pdf in the new Office 2007 but talkis with Adobe broke down)

Thanks,

Antonio