You need to have a file named 'autorun.inf' in the root of your cd.
The contents of which should be:-
[autorun]
OPEN=yourexe.exe
ICON=youricon.ico
You only need the ICON line if you want to show a different icon to
the standard when viewed in explorer.