<div>
I think best you can do is the following: Check which drive is CDRom.<br />
Add &quot;Windows Scripting Host&quot; in Project References.<br />
here some code:<br />
DIM objFSO as Scripting.FileSystemObject<wbr /><br />
DIM objDrive AS Scripting.Drive<br />
<br />
SET objFSP = NEW Scripting.FileSystemObject<wbr /><br />
FOR EACH objDrive in objFSO.Drives<br />
&nbsp; IF objDrive.DriveType = &quot;CDRom&quot; THEN<br />
&nbsp; &nbsp; DEBUG.PRINT objDrive.DriveLetter<br />
&nbsp; END IF<br />
NEXT<br />
<br />
Hope this helps
</div>


I think best you can do is the following: Check which drive is CDRom.
Add "Windows Scripting Host" in Project References.
here some code:
DIM objFSO as Scripting.FileSystemObject
DIM objDrive AS Scripting.Drive

SET objFSP = NEW Scripting.FileSystemObject
FOR EACH objDrive in objFSO.Drives
  IF objDrive.DriveType = "CDRom" THEN
    DEBUG.PRINT objDrive.DriveLetter
  END IF
NEXT

Hope this helps

<div>
TWO Excellent solutions.. pick one.. &lt;smile&gt;.<br />
<br />
NOTE: Watch your CursorType, CursorLocation and LockEdit when reading MDB data from a CDRom. Your access has to be Exclusive.
</div>


TWO Excellent solutions.. pick one.. <smile>.

NOTE: Watch your CursorType, CursorLocation and LockEdit when reading MDB data from a CDRom. Your access has to be Exclusive.

<div>
Thank you for your answer Erick. There are only a few who could answer a question as effective as you...
</div>


Thank you for your answer Erick. There are only a few who could answer a question as effective as you...

<div>
<div class="content wysiwyg-content">
I have a VB project that i want to install on harddisk. When it is installed people can open it in the Startmenu. When they click on a button i want to start a file on the CD-ROM. &nbsp;How can i refer to the &quot;CD-ROM-files&quot;. Most of the times it is D but sometimes it is E or F. 
</div>
</div>


I have a VB project that i want to install on harddisk. When it is installed people can open it in the Startmenu. When they click on a button i want to start a file on the CD-ROM.  How can i refer to the "CD-ROM-files". Most of the times it is D but sometimes it is E or F. 

Refer to files on CD-ROM

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.