I shamelessly found this VBA to search and display video path, file name, duration and size. How do I make it display the size of the file as either kb, mb or gb?
If I knew who the original author of this code was, I would give him credit.
Please Login or Register to view this content.
No "shame" in using code posted on the web for you, that's why it's there.
The existing macro is dividing filesize by 1024 (look for those instances in the code), so you will simply change that to whatever you want the display shown as.
1024 probably gives you Kb.
1024*1024 would give megabytes (1048576)
etc....
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the help. This is what it brings up for the file size:Originally Posted by JBeaucaire
-1122MB
Why the (-)?
I have attached the file that I'm working on. If I could get the correct size of the file (KB,MB,GB) in column D, that would be excellent.
I'm unable to run that macro on my 64bit system so must trust that it works for you.
As noted previously, you must edit the 1024 references (1024=kb) to the number you prefer instead.
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Thanks again for the reply.I'm unable to run that macro on my 64bit system so must trust that it works for you.
As noted previously, you must edit the 1024 references (1024=kb) to the number you prefer instead.
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
My system is 64bit, don't understand why it wouldn't work for you as well.
This is what I get when I use-2049596673024 gbPlease Login or Register to view this content.
Don't know why the negative and the file is actually 2.13gb, according to the properties.
You did not follow Jerry's instructions. Parentheses are important. Try:
LewisPlease Login or Register to view this content.
I get a run-time error of '6': Overflow when I tried that.You did not follow Jerry's instructions. Parentheses are important. Try:
LewisPlease Login or Register to view this content.
So maybe it's:
Please Login or Register to view this content.
Last edited by JBeaucaire; 02-20-2017 at 10:26 PM.
That is so close. It brings up:So maybe it's:
Please Login or Register to view this content.
-2gb
The file is 2.13gb
The math is correct. At this point I'd check the formatting in the cell.
If you want 2.13 then round to 2 places instead of 0 by replacing .../ 1024 , 0 ) with .../ 1024 , 2 )
Last edited by kev_; 02-23-2017 at 07:18 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I'm just going to have to try something else. No matter what I try on this line, it just won't bring up the correct file size.
Thanks for all the help.
This is what Kev was talking about:
Change that 0 to a 2, or however many decimal places you want to allow.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks