Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retieving cd title and placing it into excel
Is there any way to get the title of a cd and paste it into a cell?
For example, I want to be able to insert a disc into my cd-rom and run a macro that looks at the cd and records its 'title'. Title being what shows up in windows explorer next to the drive letter. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
retieving cd title and placing it into excel
Sub ShowDriveInfo(ByRef drvPath As String)
Dim fso As Object Dim drv As Object Dim s As String Set fso = CreateObject("Scripting.FileSystemObject") Set drv = fso.GetDrive(fso.GetDriveName(drvPath)) s = "Drive " & UCase(drvPath) & " " & drv.VolumeName & " " MsgBox s, vbInformation, " Drive Volume" Set drv = Nothing Set fso = Nothing End Sub '---------- Sub GetInfo() Call ShowDriveInfo("E:\") End Sub ---------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jon" wrote in message oups.com... Is there any way to get the title of a cd and paste it into a cell? For example, I want to be able to insert a disc into my cd-rom and run a macro that looks at the cd and records its 'title'. Title being what shows up in windows explorer next to the drive letter. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
retieving cd title and placing it into excel
Thanks for the reply.
I ended up using Dir("f:", vbVolume) This did what I wanted to do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbars placing at excel 2007 | Excel Discussion (Misc queries) | |||
How do I put data in excel in placing order? eg first, second, th. | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
help with placing Logo on excel sheet | Excel Discussion (Misc queries) | |||
help required with placing command buttons in Excel | Excel Programming |