Excel VBA Code

Ready-to-paste VBA macros for the jobs Excel cannot do on its own — importing data from XML files, text files and web pages, extracting text from PDFs, pulling every file name, path and size out of a folder, reading image details in bulk, and converting .doc files to .docx in one click.

There are macros for building things inside the sheet as well: data entry forms, combo boxes, progress bars, waterfall and doughnut charts, page numbers and Word Art. Plus everyday cleanup and utility code — removing blank rows and special characters, hiding gridlines and error values, protecting specific cells, finding the last used cell, calculating age or a time difference, and generating random passwords and unique IDs.

Each post explains what the code does and where to paste it, so you can adapt it rather than just copy it.