1. Try saving file as .xlsb.
2. Search for: Excel File Bloat
3. Use fewer objects in your file.
Method (3) can bloat a file when one adds and deletes many pics/objects from the clipboard to your worksheet. In the sendkeys example file that I attach here, it pastes the copied screen snippet to a scratch workbook. I avoid sendkeys solutions whenever possible. Success with those is all about focus and timing. While the API code is shorter, shorter is not always best. Many like this method though.
The 2nd attachment here uses API code too. Its code is more similar to the post #3 method. It is more robust and pastes the copied userform to a sheet and creates a pdf file. It can be easily modified to paste to a scratch workbook to make the pdf file as the other does. It better avoids file bloat and corruption issues.
As you may know, it is easy to use a whole module in one workbook that another uses. In the VBE, simply drag and drop the modules from one workbook to another from Project Explorer. If not open, select it from the VBE View menu.
These two files are good ones to put in your back pocket.
Reply With Quote