Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

Show Drive Serial Number

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub Sürücü_Seri_Numarası_Göster() On Error GoTo hata: Dim ds, d, s, t Set ds = CreateObject("Scripting.FileSystemObject") Set d = ds.GetDrive("C:") Select Case d.DriveType Case 0: t = "Bilinmiyor" Case 1: t = "Çıkarılabilir" Case 2: t = "HardDisk" Case 3: t = "Ağ" Case 4: t = "CD-ROM" Case 5: t = "RAM Disk" End Select s = "Sürücü " & d.DriveLetter & ": " & t If d.IsReady Then s = s & vbCrLf & d.SerialNumber MsgBox s Else s = s & vbCrLf & "Sürücü Hazır Değil." MsgBox s End If End hata: MsgBox "Böyle Bir Sürücü Yok" End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
You can write your comments about the error in the box below.

Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.

Similar Results

No	Macro Name
1	Show drive serial number
2	excel operators hk
3	show free space
4	Show progress in status bar: You can use this macro to show the progress of a macro code in the status bar. This code will add up to 5000 serial numbers to your sheet / page and will progress along with the status bar.
5	Detailed report on harddisk
6	learning harddiskin free space etc ..
7	harddisk serial number import into cell a1
8	How many (number of drive)
9	show changing cells
10	show changing cells
11	macro to show ip number
12	Put an asterisk at the beginning of the cell
13	show drive letter
14	show driver ready
15	Add Multiple Columns: After running this macro, you will show an input box and you must enter the number of columns you want to insert.
16	Show the cells column number or column letter
17	Hide or show pivot table fields
18	is there a printer installed
19	show file system
20	drive type show 5

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses