[quote=IanRTaylorUK post_id=530935 time=1766145299 user_id=105749]
[i]"Create an Excel VBA macro for Windows 11 / Office 365 that scans a chosen folder and all subfolders for audio files and attempts to detect embedded album art using only built-in Windows/Office APIs (no external DLLs). Output: Path, FileName, Extension, HasAlbumArt, ArtCount, SizeBytes, Width, Height. "[/i]
[/quote]

I had a brief look into this and using Excel / VBA is more complicated (and slower) than you would initially expect!

MP3Tag is probably a more reliable and faster approach using the built-in %CoverWidth% and %CoverHeight%

If your Album Art is stored as both a Tag within the media files AND as a JPEG in the Album folder, then you can view the size, Height and Width using Windows File Explorer.

For example, if ALL your media files reside on a hard disk assigned the drive letter [b]M:[/b], then point to this drive in File Explorer and use the search criterion[b][i] kind:picture[/i][/b] and a "details" view. Right click on the columns to add Size / Width / Height.

In my case ALL my album art is stored in both the file tags AND the album folder - as [b]folder.jpg[/b]. My intention is that the [b]folder.jpg[/b] is the same album artwork as that stored in the tags! 8655 items ranging from 100 x 100 pixels to 5653 x 6509, or 2 KB to 7595 KB.

If you wish to delve deeper into the media files "tagged" artwork, then I would suggest using your preferred AI agent to suggest a script to do so. For example, you might want to start with:

[i]"Create an Excel VBA macro for Windows 11 / Office 365 that scans a chosen folder and all subfolders for audio files and attempts to detect embedded album art using only built-in Windows/Office APIs (no external DLLs). Output: Path, FileName, Extension, HasAlbumArt, ArtCount, SizeBytes, Width, Height. "[/i]

No one has responded to my post. Does anyone know of a way to see the album art size? I have found album art files automatically added that were over a MB when a 10KB file is usually sufficient. If no one knows how to do this in Media Monkey, does anyone know of another program that does? I would like to identify the files with the very large art files and then I can find new ones with MM

Could we have a way to list the album art size and sort to find the largest art files to be able to download a different file to replace them with smaller files. It would be nice if MM could rescale the art files to a max resolution or file size. 300x300 resolution seems to be an adequate size most images and keeps the size to a reasonable number. If we could just list the art size in the database, we could determine if it would be worth editing.