Hello,

Im writing a program in visual basic and i have to manualy execute the macro from the CD.

But my macro has to look up the CD path automaticly wether the drive is D, E or F and so on.

Because there are files on the CD that need to be accessed when the macro is being runned.

Can anyone help me with the code that i need for this?

Coen