Hi Garry

I've also tried xlQualityHigh and the result didn't appear a whole
lot better than xlQualityStandard.

When you say "I try to resize my images to the 'LargeWeb' spec in the
image viewer so that they're optimized for CHM, WebHelp, hard copy
print, and ebook output," where is that . . . I suspect it's not in
Excel?

The issue I have is that these macros are a part of a larger workbook
where engineers go out to inspect equipment, take photos that go into
an Excel report spreadsheet. Macros import the photos to specific
cells in the spreadsheet; then one of the macros Saves As a PDF. The
idea is to get the photos in the spreadsheet and then a pdf with as
little effort as possible on their part. The result for me is that
I'm a bit hogtied as to what I can do - using Acrobat Pro or any
other app "external" to Excel is probably out of the question. I
suspect I'm going to have an option that totally protects the
workbook, saves as a new name, rather than as a PDF. Unless you have
any better ideas (Always welcome!)?

Thanks very much (again) for your help.

Steve

Steve,
I have a simlar scenario where photos are taken during a retrofit for
DPF installations, and another for roofing repairs. You just need a
good PDF printer that lets you specify the output resolution DPI! Has
nothing to do with Excel, but rather Adobe PDF being used. You can
specify up to 1200DPI quality for resolution as well as 'print quality'
for the general output. 'Print quality' is used for printing hardcopy
books/docs, or ebook PDFs.

I use either Office Picture Manager or Windows Photo Viewer for the
resizing mentioned above. I used to do this in Paint Shop Pro when
there were few to do, but either of the aforementioned apps are better
for batch resizing to more responsible file sizes while maintaining
decent publishing quality.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion