Скачать или смотреть Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names

Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names

How to use Macros

Step 1. Open excel and then press Alt + F11 to open VBA editor
Step 2. Insert a module from insert tab
Step 3. Copy the below given Macro as it is and paste it in the VBA Editor
Step 4. Edit the file path as per your requirement
Step 4. Press CTRL + S and close
Step 5. Just go to view and select the Macro to run


Sub COPYDIR()

Dim FILENAME As String, FOLDER As String, ROW As Integer
'Define the variables to store filename and foldername

ROW = 1
'It will allow macro to select row no 1 in excel for pasting the filename

FOLDER = "C:\Users\91981\Desktop\"

'edit the folder path as per directory in which files and folder are available and you want to copy it in excel file

FILENAME = dir(FOLDER, vbDirectory)

Do While FILENAME ""
' do while allows the macros to execute again and again until the filename is not blank ... please add less than greater than sign after

Cells(ROW, 1) = FILENAME
'copies the file in row 1

FILENAME = dir
ROW = ROW + 1
'It allows the loop to execute again and again until the above condition not met

Loop
End Sub



Link of My Videos

Count duplicate value using IF and sort function in a very large excel data
   • Count duplicate values using IF Function w...  

Top 5 shortcut key used in Excel
   • Most Commonly/frequently used top five exc...  

Count duplicate value using countIF Function
   • Count duplicate values using countIF funct...  

How to split one single big file into multiple small files in size so to enable to send it through email
   • How to SPLIT a big file  of any format usi...  

How to reduce file size even better than zip filing using zipx option of WINZIP
   • Reduce file size by using WINZIP advance O...  

How to merge multiple sheets into one excel sheet
   • VBA Macro to merge/ console multiple Sheet...  

How to delete a sheet using MACRO
   • VBA Macro to delete    Sheet in a workbook...  

How to create a Macro to add a new sheet automatically
   • Macro to add / create a new sheet in an ex...  


How to create a password protected excel file
   • How to create password protected excel fil...  

Create your first Macro in Excel VBA
   • My First Excel VBA Macro program. How to w...  

How to use IFERROR Function with Vlookup Function
   • IFERROR with Vlookup function is used to r...  

Use of Hlookup Function
   • Use of HLOOKUP FUNCTION - HLOOKUP FUNCTION...  

Use of Vlookup Function
   • VLOOKUP FUNCTION - Use VLOOKUP when you ne...  

Use of Lookup Function
   • LOOKUP FUNCTION -A value that LOOKUP searc...  


Create multiple files from a single file based on a criteria using macros in excel VBA
   • Use of Macro to Un-merge / Split data from...  

MID Function - Extract number / words from a dynamic position / position not fixed
   • MID Function - Extract number / words from...  

Change date format using Text Function
   • Change date format using Text Function  

How to protect rows or columns - Allow edit range allows you to edit only selected ranges in Excel
   • How to protect rows or  columns - Allow ed...  

Concatenate function used with text function, joins two or more text / numbers into one
   • Concatenate function used with text functi...  

Text Function - change the way a number /text / date appears
   • Text Function - change the way a number /t...  

How to use Subtotal function to count visible cells only in a given range
   • How to use Subtotal function to count visi...  

Use of Subtotal function to sum / total of all visible cell in a given range
   • Use of Subtotal function to sum / total of...  

Use of Dollar Sign/ How to use $ Sign, Freeze rows or column and both
   • Use of Dollar Sign/ How to use $ Sign, Fre...  

How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
   • How to console / Merge multiple text files...  

How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
   • How to use SUMIFS function, sums a selecte...  

How to create aging / Bucketing using IF Function in excel
   • How to create aging / Bucketing using IF F...  

SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
   • How to use SUMIFS function, sums a selecte...  

How to create aging / Bucketing using IF Function in excel
   • How to create aging / Bucketing using IF F...  

SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
   • SUMIF Function - Sumif function, sums up a...  

Use of Countif Function - How to count cells in a range with a condition / Criteria
   • Use of Countif Function  - How to count ce...  

Use of CountBlank Function - Count empty cells in a given range in Excel
   • Use of CountBlank Function - Count empty c...  

Use of CountA Function- CountA function use and comparison/Difference of CountA with Count function
   • Use of CountA Function- CountA function us...  

Count Function - How to count numeric value in MS Excel using Count Function
   • Count Function - How to count numeric valu...