?
Solved

How to get CD TYPE?

Posted on 1998-06-10
2
Medium Priority
?
127 Views
Last Modified: 2012-08-14
How to get a CD info, using VB. I mean is in the CD-ROM AudioCD or Data CD?

thank you.
0
Comment
Question by:beciakk
[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
  • 2
2 Comments
 
LVL 7

Accepted Solution

by:
kamall earned 120 total points
ID: 1463026
You can use a file list box and set its path to the CD-ROM drive, then refresh it using File1.Refresh . Then check if the file list box has any items in the ListCount property. If it has, then the CD is a Data CD.
Regards
0
 
LVL 7

Expert Comment

by:kamall
ID: 1463027
Oh..., one thing I forgot....
You must put:
On Error Resume Next
at the beginning of your code in the SUB where you put the code for the File list box, because otherwise you will get an error if the CD is an Audio CD or when there is no CD in the drive.
Regards
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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 Month9 days, 17 hours left to enroll

762 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