cd drive again

[Jay=B]

I know I just ask this question but I guess I didn't ask it distinctly. Does anyone know how to get the drive of the cd-rom of which my program is on. Some computers have more than one cd-rom drive. I just want to know get the one a user is working on.

thanks in advance

Does anyone know how to get the drive of the cd-rom of which my program is on.

Strdrive = Left$(App.Path, 3)
Msgbox "Program is located on the " & Strdrive & " drive."