-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sub folder
-
How to list all Path, Filenames & Filesizes
I have some coding (from http://www.mrexcel.com/forum/excel-questions/471508-list-properties-all-files-folder.html ) to get filesize. Public Function FileSize() Dim FSO As Object Set FSO = CreateObject("scripting.filesystemobject") FileSize = FSO.FileSize("C:\Windows\Windows.exe") End Function...- JARHTMD
- Thread
- filename filesize path sub folder
- Replies: 7
- Forum: Excel Questions
-
L
Search through folders and subfolders to find a file and open it.
Hi I have started this macro but I am having a problem (Labeled '????? below). I am tring to find a file which is typically .doc/docx/.pdf within a folder or its subbfolders then open it if found. Can anyone modify my solution below to to alos searchthrough all subfolders? file =...- lance01
- Thread
- folder open file search files in folder sub folder sub folders
- Replies: 0
- Forum: Excel Questions
-
T
Open files within sub folders
Hi I found some code on Mr Excel where it will go into sub folders and get the names of all the files within these folders (see below) but i wanted to know if there was anyway i could amend this so it opens the files up in name or date order? Private Sub recurseSubFolders(ByRef Folder As...- tasander
- Thread
- name order open all files sub folder
- Replies: 4
- Forum: Excel Questions
