Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba number format file size

Quaint Quetzal answered on January 27, 2021 Popularity 1/10 Helpfulness 1/10

answer excel vba number format file size

related excel vba number format file size

excel vba number format file size

Comment

[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

Popularity 1/10 Helpfulness 1/10 Language vb

Source: social.msdn.microsoft.com

Tags: excel size vba

Link to this answer
Share Copy Link

Contributed on Jan 27 2021

Quaint Quetzal

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba number format file size

Comment

Select Case objFile.Size
        Case 0 To 1023
            Cells(NextRow, "D").Value = Format(objFile.Size, "0") & "B"
        Case 1024 To 1048575
            Cells(NextRow, "D").Value = Format(objFile.Size / 1024, "0") & "KB"
        Case 1048576 To 1073741823
            Cells(NextRow, "D").Value = Format(objFile.Size / 1048576, "0") & "MB"
        Case 1073741824 To 1.11111111111074E+20
            Cells(NextRow, "D").Value = Format(objFile.Size / 1073741823, "0.00") & "GB"
End Select

Popularity 1/10 Helpfulness 1/10 Language vb

Source: www.mrexcel.com

Tags: excel size vba

Link to this answer
Share Copy Link

Contributed on Jan 27 2021

Quaint Quetzal

0 Answers Avg Quality 2/10

excel vba number format file size

Contents

More Related Answers

excel vba number format file size

Closely Related Answers

excel vba number format file size

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.