LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default Find Folder Size

I would like to give the user a choice of either if possible.
Regards
Charles

"NickHK" wrote:

You mean search the entire drive+root folder or sub folders for files that
have exactly the same name and extension ?

NickHK

"vqthomf" ...
Files with the same name.
Regards
Charles

"Halim" wrote:

Hi,
What you mean with duplicate files?
If all type of files you can use :

Dim mydir
mydir = Dir("C:\*.*")
Do While mydir < ""
ListBox1.AddItem mydir
mydir = Dir
Loop

--

Regards,

Halim


"Bob Phillips" wrote:

Sub FolderSize()
Dim oFSO As Object

Set oFSO = CreateObject("Scripting.FileSystemobject")
MsgBox Format(oFSO.getfolder("C:\myTest").Size, "#,##0 ""bytes""")

Set oFSO = Nothing
End Sub


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vqthomf" wrote in message
...
Hi Is it possible to find a folder size, and also how can I list
duplicate
files into a listbox any help will be much appreciated thanks.
Charles






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Folder Size/File Count DMc2004 Excel Programming 2 August 2nd 06 07:59 AM
Getting number of files within a sub-folder and its size Jim Cone Excel Programming 1 July 11th 06 02:02 PM
I deleted 99% of data from excel file. Folder Size remains unchang msnut Excel Discussion (Misc queries) 2 September 21st 05 01:44 PM
Folder Size Andibevan[_2_] Excel Programming 3 June 1st 05 03:42 PM
How to find out the size of a variable-size array ? Adrian[_7_] Excel Programming 1 July 6th 04 09:12 AM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"