control of all attachments Free Excel Macros (VBA) | Excel Programs

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)

Control Of All Attachments

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php

Sub Eklenti()
  Dim i As Integer
  Dim Eklenti

Cells(1, 1).Value = "Eklenti Adı"
  Cells(1, 2).Value = "Eklenti Yolu"
  Cells(1, 3).Value = "Eklenti Boyutu"
  Cells(1, 4).Value = "Eklentiyi Oluşturma Tarihi"
  Cells(1, 5).Value = "Dosya Tipi"

Set Eklenti = CreateObject("Scripting.FileSystemObject")

For i = 1 To Application.AddIns.Count
    Cells(i + 1, 1).Value = Application.AddIns(i).Name 'adı
    Cells(i + 1, 2).Value = Application.AddIns(i).Path 'Dosya Yolu
    Cells(i + 1, 3).Value = Int(Eklenti.GetFile(Application.AddIns(i).FullName).Size / 1024) & " Kb"
    Cells(i + 1, 4).Value =   Eklenti.GetFile(Application.AddIns(i).FullName).DateCreated
    Cells(i + 1, 5).Value = Eklenti.GetFile(Application.AddIns(i).FullName).Type
    If Application.AddIns(i).Installed = False Then
      Cells(i + 1, 6).Value = "Aktif Değil"
    Else
      Cells(i + 1, 6).Value = "Aktif"
    End If
  Next i
  Columns("A:F").EntireColumn.AutoFit
End Sub

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	control of all attachments
2	excel operators hk
3	fonts in word
4	clears the contents of all textboxes
5	saving and sorting alphabetically
6	list fonts with samples
7	excel fonts 2
8	WorksheetThis macro code will help you easily control and manage worksheets and save you a lot of time. Hide all except active worksheet: Now if you want to hide all worksheets other than the active worksheet in your workbook, say. This macro code does this for you.
9	Add menu to file edit bar delete
10	excelin all menu pushbutton pictures
11	add time as menu
12	add time as menu (most reliable)
13	Number of all objects in userform
14	Cancel copy and paste
15	Highlight the Maximum Value in Range: Controls all selected cells and is highlighted by the maximum value of the cell.
16	Selecting all of the content when the textbox is clicked
17	Create your own extensions and functions in excel
18	shortcut keys list
19	Can the characters typed in the inputbox appear as "*****" (password or password characters)?
20	find-delete-change-save codes2

Excel Free Macros (VBA)

Control Of All Attachments

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords