lists all macros in macros in excel files in a folder of your choice Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub sirala() 
Dim sd As VBComponent 
Dim kodlar As CodeModule 
Dim Dosya 
Dim wb As Workbook

i = 2 
On Error Resume Next 
Application.DisplayAlerts = False

Set ObjFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Klasör Seçiniz...", &H4, "") 
pth = ObjFolder.items.Item.Path

ChDir (pth) 
Dosya = Dir("*.xls") 
While Dosya  "" 
Set wb = Workbooks.Open(pth & "" & Dosya) 
Windows(wb.Name).Visible = False

For Each sd In wb.VBProject.VBComponents 
Set kodlar = sd.CodeModule 
  
  basla = kodlar.CountOfDeclarationLines + 1 
   If Err.Number = 0 Then 
       Do Until basla >= kodlar.CountOfLines 
       If Err.Number  0 Then Err.Clear: Exit Do 
        ThisWorkbook.Sheets(1).Cells(i, "A") = pth & "" & Dosya 
        ThisWorkbook.Sheets(1).Cells(i, "B") = kodlar.ProcOfLine(basla, vbext_pk_Proc) 
        ThisWorkbook.Sheets(1).Cells(i, "C") = sd.Name 
        basla = basla + kodlar.ProcCountLines(kodlar.ProcOfLine(basla, vbext_pk_Proc), vbext_pk_Proc) 
        i = i + 1 
       Loop 
     Else 
      Err.Clear 
   End If 
Next

Dosya = Dir 
wb.Close False 
Wend 
End Sub

No	Macro Name
1	lists all macros in macros in excel files in a folder of your choice
2	excel operators hk
3	desktop icon creation
4	Codes that prevent and open the vba window and access codes
5	lists the named cells in detail on the wb_names sheet / page
6	Open all Excel files in folder
7	Add menu to file edit bar delete
8	Attendance Codes workbook-level tasks & nbsp; it will help you perform it easily and with minimal effort. & Nbsp; Create a Backup of a Current Workbook: This is one of the most useful macros that can help you save a backup file of a current workbook. Saves a backup file in the directory where your current file is saved. & Nbsp; It will also add the name of the file to the current date.
9	Create your own extensions and functions in excel
10	List the names of Excel files in a folder then give them a link
11	list of all macros
12	Organize paths in folder and file macros
13	if you say your macros are hidden
14	prints the path and name of the file to the cell
15	calculator on / off
16	macros that determine and cancel your workspace on your worksheet
17	pdf preview
18	macros box and macros appear
19	macros that determine and cancel your workspace on your sheet / page
20	lists xls files in the specified path from the active cell

Excel Free Macros (VBA)

Lists All Macros İn Macros İn Excel Files İn A Folder Of Your Choice

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords