1
Webandmacros logo
 
2
   
| Make Homepage | Add to Favorites | Recommend |
 
3

:. HOME
 
:. EXCEL MACROS
 
 
:. ARTICLES

 

Macros Excel to list and organize files mp3, pdf, xls ....

 

In many occasions we want to organize all the files of our computer, we have our spreadsheets, photographs, files of music. in different folders, sometimes we do not know if that files contains a CD that we recordered long time ago. But, with macros VBA we can find them quickly, therefore we could organize and obtain a list with the names of files, the sizes that it occupies, the folder where it is contained, the date of creation..

 

With macros vba in Excel we can organize and list our files.

 

 

 

 

 

In our PC we have many files of music, photographs and images, spread sheets PDF., with this macro you will be able to find all the files, showing information as the size, the folder and the route where the files reside...

 

Excel Macro VBA- organize and list the files

In order to execute the macro that list of the files we should introduce two input data:

Input datas :

Macro excel to list and organize files - input datas - extension of the file and route.

Type of file : we write the extension of the type of file that we want to seek and to list always with *. in front of the extension.

Example:

To list all the files excel: *. xls.

To list all the files of music: *.mp3, *.wma

To list files pdf: *.pdf

Location : We write the route where we want to look for and to list the files by the following ways: [UNIT]: \ [PRINCIPAL FOLDER] / [SUBFOLDER 1]/

Example: we want to list all the files of an older that one finds in the unit C whose name is "my files".

C:\my files

We want to list all the files of our hand disk:

C: /

Listed report of files:

When pressing the bottom "List files", the macro vba is executed, it look for all the files offering the following information.

Complete route : Writes the name of the complete route where it is the file and the name of the file.

Name : Writes the name of the file without including the route where it is.

Number : It numbers the files correlatively as they have arranged on the hard disk .

Data creation : Date when it was created.

Data Access : Indicates the last time it was opened.

Data modified : Indicates the last modification.

KB : Indicates the size of the file in Kbytes.

Macro excel to list and  organize files - input datas - extension of the file and route.

Macro excel to list and organize archives - List report of found files.

Macro excel to list and organize files - properties report of files.

Alerts.

Once the macro vba is executed, an alert will appear to report us the total files and the total size of all the files occupied.

Alert macro excel to list and organize files.

In case the files would not be found, another alert will appear.

Alert macro excel to list and organize files.

If you like, share it

 

Downloads Excel Macros  
You have enjoyed this Excel macro, it is available in downloads Excel Macros VBA

 

Commentary Excel Macros.  
If you want to add some comments about this macro you can do it here

 

VALUE EXCEL MACRO

Bad Excellent

Google & Webandmacros.com Search engine.
Google
 

 
4
 
 
   
www.webandmacros.netWorld webandmacros.
     
webandmacros.net 2007 - 2014
     
5
6