Hi,
Take a look at this. It might get a bit more information than you require but it does return the Drive letter of the CD-rom

http://www.vbsquare.com/tips/tip398.html

hope this helps

Shaun