Savepicture

W

Wike05

I found this code on a website and that will copy a range as a picture. I
also need it too save it as a picture on our network. Can you help?
Worksheets("Sheet1").Range("A3:D12").CopyPicture _
Appearance:=xlScreen, Format:=xlBitmap
 
X

XP

Not sure which version of XL you are using, but you could turn on the macro
recorder and print to a .tif. Set the printer name to MODI (Microsoft
Document Image Writer) and pick your file destination.

HTH
 
W

Wike05

Excel 2002

XP said:
Not sure which version of XL you are using, but you could turn on the macro
recorder and print to a .tif. Set the printer name to MODI (Microsoft
Document Image Writer) and pick your file destination.

HTH
Click to expand...
 

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

CopyPicture method of range class failed using RangeName 5
Error message 1004 2
How to paste a image into a VB UserFrame in Excel? 5
Best format to export Excel Range to picture?? WMF?? 5
Pasted this morning, but not now 2
How to display the merge function "url" of a picture? 0
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003] 1
Problem copying table data as a picture onto chartsheet 8

Top