Solved

How to get the cdrom drive letter.

Posted on 1998-06-17
1
167 Views
Last Modified: 2010-05-03

I'm looking for a function or method to get the letter of the cdrom drive..
Is there any function or entry in the register??
0
Comment
Question by:ineila
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
alamo earned 50 total points
ID: 1463497
I assume you mean for Win95 or NT.

This function returns the CDROM drive letter, or "" if none found:

Private Declare Function GetDriveType Lib "kernel32" Alias _
     "GetDriveTypeA" (ByVal sDrive As String) As Long
Private Const DRIVE_CDROM = 5

Public Function GetCDRomDrive() As String
 Dim i As Integer
 Dim sDrive As String
 GetCDRomDrive = ""      ' in case none found
 For i = 0 To 25
  sDrive = Chr$(i + 64)
  If GetDriveType(sDrive & ":\") = DRIVE_CDROM Then
   GetCDRomDrive = sDrive
   Exit For
  End If
 Next
End Function

Hope this helps, good luck!
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month5 days, 19 hours left to enroll

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question