compress

This code was written for me by @Jaafar Tribak long ago. I use it to compress larger images in a folder Now I want to tweak it a little bi: Option Explicit Private Enum PictureTypeConstants vbPicTypeNone = 0 vbPicTypeBitmap = 1 vbPicTypeMetafile = 2 vbPicTypeIcon = 3...

So I am using this to add pictures to my file. I am essentially creating an asset list and want to put the picture with the asset on that line. It essentially then creates a link to open the photo in its original size. The problem is it works sometimes. I suspect it might have to do with the...

So I have a simple 2-column table; basically just a list of names where each has a corresponding number. Simply, I want to comb through the list and find things like "| Company A | 5 |" and "| Company A Inc. | 5 |" and combine them. I guess this could turn into "| Company A | 10 |" or "| Company...

It would be appreciated if anyone can recommend software to compress large Excel files without zipping the file

HelloWorld, I have the feeling there is a way to compress image files with a vba script. If anyone agrees to that can we take up that challenge? Basically, I will be compressing from a folder. And will like the smallest size possible. Say below 100kb . Thanks in advance Kelly

Hello All, I hope all of you are doing well. Can you kindly assist me on the below. I am struggling for months to get this code. I am not an expert at coding hence requesting you all to help me out. Below are the requirements the code. 1. The VBA should go through all the folder and...

Hi I'm attempting to shrink some excel workbooks with lots of graphics inside. I have found the menu options of 'Picture Tools' > 'Format' > 'Compress Pictures' function to be very useful in achieving this. Going through each individual pictures on each sheet and across many workbooks will be...

Hello, I would like to create a VBA to automate the "Compress Pictures" in a batch. I've been searching the forum and realize that the Excel 2016 version do not have such code exist, however, this can be done by some "Keyboard alt key" recording. Unfortunately, I can 't find any solution for...

Hello all, I have very little experience with VBA, but I'm trying to write a code that will copy cells in a range that are not empty, then continue down the column to the next range and copy those values until another non-empty cell appears, then move to the next range. For instance: I have a...

Hi Everybody, I was wondering whether anybody could help me ZIP files using Excel VBA and the windows .ZIP file creator please? In Cell: A1, File name and file path 1 to be zipped A2, File name and file path 2 to be zipped A3, File name and file path 3 to be zipped A4, Name of ZIP file to be...

So I have an excel file with 350,000 rows of data (I'm using excel 2010) and I need to create a bunch of tabs with some pivot tables to recap the data in meaningful ways. I've created one tab already, but the file size is quite large (115MB). Is my best course of action to just deal with a...

I have a pivot table, in Excel 2007, that is used to track the schedules of employees time (the tab name is “All View” – there are multiple tabs within this workbook) this table has multiple “Office” locations, and also has multiple employees within each office. In addition, the number of...