1. kelly mort

    Code Amendment Needed: Browse And Compress An Image Instead Of Compressing Entire Images In A Folder

    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...
  2. O

    Inserting Image into cell with VBA

    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...
  3. F

    Compress Duplicates in Table

    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...
  4. H

    Software to compress Excel files

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

    Compress images with vba code

    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
  6. L

    VBA code required to zip files on folders / Sub folders

    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...
  7. R

    Compress All Pictures in Excel Workbook

    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...
  8. T

    Using VBA to compress pictures

    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...
  9. J

    VBA Code to Copy Non-Empty Cells in Range

    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...
  10. B

    HELP!! need to automate ZIP file creation...

    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...
  11. L

    File Size Conundrum

    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...
  12. S

    Pivot Table Macro - Compress employees schedule into 1 row on new tab

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back