Ed Covney
asked on
Excel 2010: Function to acquire file size in bytes
For the purpose of planning play list play times, is there an Excel function to get a file's size in bytes?
For example column A, I list MP3 files by name, for example: (The file in A34)
E:\Music\PlayList1\The Little River Band - Down On The Border.MP3
Is there an excel function such as "FileSizeOf(A34)" and return 4022196
(the actual size of the file in bytes)
TIA - Ed
For example column A, I list MP3 files by name, for example: (The file in A34)
E:\Music\PlayList1\The Little River Band - Down On The Border.MP3
Is there an excel function such as "FileSizeOf(A34)" and return 4022196
(the actual size of the file in bytes)
TIA - Ed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dave - EXCELLENT !!
Now I just have to figure out how to import your macro into my spreadsheet.
I have lots to learn, thanks for a great start.
Ed
Now I just have to figure out how to import your macro into my spreadsheet.
I have lots to learn, thanks for a great start.
Ed
See attached.
Dave
fileSizeInfo-r2.xls