It only runs for me only with Excel closed prior to running (WinXP & Office XP). I've noticed that at times, Excel does not show on the taskbar but is present in task manager (not your problem but may explain why others are having problems and getting the 1004 error).

However, something isn't working properly for me......

The "Albums" page empty and on the "Artists" page I just get a single column of numbers (one per line, aligned to LH margin) which in fact are the track lengths (they also appear in column D "length" in Excel).