Set Print Area = Image??

D

dave_d

Is there a VBA routine out there to set a print area, but
dump it to an image file instead of sending it to a
printer ? I keep getting asked for files generated by my
workbooks, but due to security, I don't want to send my
equations or workflows by sending the entire workbooks. I
would rather have something more elegant than "Print
Screen" and going through our IS group to purchase screen
capture software is like dealing with the devil. Any
ideas out there ? Thanks,
dave_d
 
K

keepitcool

Dave,

consider using PDF's for distribution,
rather then screendumps(=bitmaps) or gifs..


you'd need Acrobat (not just the reader) for that, then you can just
print to Acrobat Distiller and you have what you need.

I think you'll find some free (shareware) alternatives if you browse for
them.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
K

kiat

1. copy the source range and paste special as values in another workbook,
there won't be any formula in new workbook
2. copy the source range and paste it in Paint and saveas in the picture
format of your choice

Either can be automated with VBA.
 

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

Top