lior03
07-25-2005, 05:22 AM
hello
i have a huge workbook - 6,411,550 bytes.
i want excel to issue a warning when it reaches 7,500,000 bytes in size.
Sub sizere()
Dim x As String
x = ActiveWorkbook.Name
If filesize(x) >= 7500000 Then
MsgBox " this workbook is too big"
Else
MsgBox " watch it !!!!"
End If
End Sub
thanks
i have a huge workbook - 6,411,550 bytes.
i want excel to issue a warning when it reaches 7,500,000 bytes in size.
Sub sizere()
Dim x As String
x = ActiveWorkbook.Name
If filesize(x) >= 7500000 Then
MsgBox " this workbook is too big"
Else
MsgBox " watch it !!!!"
End If
End Sub
thanks