OK, so I couldn't try it, so it didn't work. But it was close. This I have tried and it does work...

You would need to use .Artist.Name instead of .ArtistName
and .Name instead of .AlbumName.
Hence the appropriate part of your script becomes...

' Add space to empty fields, so table is displayed correctly (Cell borders do not show up for empty cells)
Dim artistname
artistname = itm.Artist.Name
if artistname="" then
artistname = "& n b s p"
end if

If I have copied that in correctly, the script should now run (mine does).

Good luck, AlanB

OK, so I couldn't try it, so it didn't work. But it was close. This I have tried and it does work...

You would need to use .Artist.Name instead of .ArtistNameand .Name instead of .AlbumName. Hence the appropriate part of your script becomes...

' Add space to empty fields, so table is displayed correctly (Cell borders do not show up for empty cells) Dim artistname artistname = itm.Artist.Name if artistname="" then artistname = [color=red]"& n b s p"[/color] end if

I suspect that you are trying to access the wrong member property. All the previous scripts have obtained a song list and hence rely on the interfaces ISDBSongList and hence .Item yields a ISDBSongData (i.e. .ArtistName, AlbumName etc). However, you have used the ISDBSongList .Albums member to obtain an album list, hence the .Item property will yield a ISDBAlbum instead, hence you need to consider its members.

I this is correct, then you would need to use .Artist instead of .ArtistName and .Name instead of .AlbumName.

I hope this is correct, in which case it might help.

AlanB

I did it using Access, but a script solution would be better (but I am still learning here also).

Since you haven't received an answer from anyone more knowlegable, I offer my suggestion.Refereing to the idl already mentioned athttp://www.songs-db.com/Songs-DB.idl

I suspect that you are trying to access the wrong member property. All the previous scripts have obtained a song list and hence rely on the interfaces ISDBSongList and hence .Item yields a ISDBSongData (i.e. .ArtistName, AlbumName etc). However, you have used the ISDBSongList .Albums member to obtain an album list, hence the .Item property will yield a ISDBAlbum instead, hence you need to consider its members.

I this is correct, then you would need to use .Artist instead of .ArtistName and .Name instead of .AlbumName.

I've looked at those, but I must be too dense to make a lot of sense out of them. I am totally new to writing scripts.

I've created two seperate vbscripts, one for exporting all my songs to HTML which works fine. However the one for the Artist/Albums doesn't work. Really these are just edited versions of the HTML section of the original. Here is the offending script:

Think anyone more knowledgable than me can take a look at my code and see what I am doing wrong?

Frodo

I've looked at those, but I must be too dense to make a lot of sense out of them. I am totally new to writing scripts.

I've created two seperate vbscripts, one for exporting all my songs to HTML which works fine. However the one for the Artist/Albums doesn't work. Really these are just edited versions of the HTML section of the original. Here is the offending script:

Argh, that part works, but now I'm getting other errors from the script. It doesn't like where I've tried to dim the Year and Album stuff. I'll look at the xml portion of the original script and see what it's doing.

Frodo

Argh, that part works, but now I'm getting other errors from the script. It doesn't like where I've tried to dim the Year and Album stuff. I'll look at the xml portion of the original script and see what it's doing.

Argh, that part works, but now I'm getting other errors from the script. It doesn't like where I've tried to dim the Year and Album stuff. I'll look at the xml portion of the original script and see what it's doing.

Frodo

Argh, that part works, but now I'm getting other errors from the script. It doesn't like where I've tried to dim the Year and Album stuff. I'll look at the xml portion of the original script and see what it's doing.