- Feb 5, 2006
- Office Version
Good day. This may take a while to explain. I am running Excel out of Office365 (updated) on Windows 10 Home. I have created a worksheet titled Music Database that contains 8 File Properties extracted from my Music folder that contains 4500 songs in MP3 format. The Macro examines the Music folder and creates a worksheet titled DB to list the data. I also have a worksheet titled Song List to list songs of my choosing using XLOOKUP in a formula for each desired File Property that searches the DB worksheet and returns the desired File Property listed in the DB worksheet. This all works. The next step is the problem. In the DB worksheet there are several songs that have identical Titles, but different Artists. When the search takes place for a given Title, the first match found is the one entered into the Song List. The Music folder contains two File Properties, "Name" and "Title". The Name property contains the actual file name along with the File Type. ie: "Anytime (1).MP3" - Since this song was recorded not only by Eddie Fisher but also by Journey, the Name for the file includes separators (1) and (2) to allow duplicate names to be filed. There are also some songs with three different artists Using (1), (2), and (3) as separators. To avoid having to enter the complete File Name including the separator and the File Format to make the XLOOKUP work, the Macro that creates the DB worksheet extracts the File Property "Title" instead of the "Name". The Title in each of the songs with multiple Artists stores only the song Title without the separators. Thus, when the DB worksheet is created, multiple songs are listed with the same Title. That means that when I execute a search for a song with multiple artists, the result is always the first one found. Is there a way to modify the Macro to indicate to me the fact that there are multiple artists for that song and allow me to choose which one I want? I realize that it might not be able to make that happen. Any help is appreciated.