How to compress picture in word using vba

#How to compress picture in word using vba driver#
#How to compress picture in word using vba manual#

#How to compress picture in word using vba manual#

We all transfer data from excel to word manually which becomes tedious sometimes when it comes to performing the same steps too many times in a day in order to avoid the manual steps, we will write VBA code to do all the steps. However, excel data can be copied & pasted into word & then saved as word document. Word application cannot open excel files directly. In excel, there is no such feature that could allow you to convert the data from excel workbook to word file. If you paste the image instead of inserting it, Word may convert the image to a bitmap version that is not the greatest for some purposes.If you are required to copy & paste data from multiple excel worksheets into MS Word then you should read this article. This results in the highest resolution (provided your images are higher resolution than 220 dpi), but it also results in the largest document file sizes.ДЇinally, whatever format you decide upon for your graphics, you'll want to use the Picture tool on the Insert tab of the ribbon to actually insert the image into your document. When set, this causes Word to ignore whatever you have specified in the Default Resolution control and, instead, include any pasted images at their original resolution. If 220 dpi is not sufficiently high-res for your needs, then you should (in step 4) click the Do Not Compress Images check box. When you perform these steps, Word converts any high-resolution images to the resolution you specified in step 4.

Make sure the Set Default Target Output or Default Resolution (depending on your version of Word) control is set to 220 ppi.The image settings in the Word Options dialog box. Scroll down until you see the Image Size and Quality section.Click Advanced at the left side of the dialog box.(Click the File tab of the ribbon and then click Options.) Word allows you to do this in Word 2010 and later versions: You should also consider using a graphics program to resize the graphic to whatever final size you need in the Word document.ДЄnother thing you will want to do is to configure Word so that it doesn't compress images. It has great resolution, but the file sizes are much smaller than corresponding TIF files. First, export your image using a format such as PNG. If the large file sizes are a problem, there are a couple of things you might try. The reason is that Word can work with TIF files and scale them to whatever size you need. The resulting image file will be rather large, but it will be just as crisp and clear as you expect.

Normally, for most printers, either 300 dpi or 600 dpi will work just fine. Instead, choose to export your image to a high-resolution TIF format. Since there are so many things that have to be 'just right' in order for EPS files to work properly with Word, it is best to not rely on them unless you have to.

#How to compress picture in word using vba driver#

If you are using a different type of printer-one that doesn't understand PostScript-or if you are using a non-PostScript printer driver with a PostScript printer, then what you see will be what you see on the screen-the low-resolution preview image for the EPS. If you are using a PostScript printer (and the correct printer driver), then the EPS graphic will be printed correctly because PostScript is able to decode the EPS files correctly. When you use Word to print the EPS file, what you see on the printout depends on the type of printer you are using. This preview is generated by the program that created the EPS file and it is typically at a low resolution, such as 72 dpi. Most programs, including Word, do not decode the math to the screen, but instead rely upon a low-resolution 'preview' of the image. EPS is a vector format, meaning that a graphic file consists of many separate 'objects' that are mathematically defined. First of all, you may want to strongly consider not using EPS for your high-resolution graphics that will end up in a Word document. Nina wonders what the best way is to embed a high-resolution graphic in her letterhead so that it appears with the crispness and clarity she expects. The resulting graphic looks terrible in Word the text in graphic format doesn't appear as crisp or sharp as the original text version of the address. Word automatically fits the image to the available space, which means it is resized to 11% of its original. This makes the original size of the graphic (according to Word) huge, something like 69 inches. When she did that, however, the EPS file is treated in Word as if it is 72 dpi. She saved the text portion out as an EPS vector file, thinking this would provide the best resolution when she inserted the graphic into Word. Nina is creating a letterhead, and she wants to use a graphic for the address portion of the letterhead.