Current File Size of Workbook

[jeffcravener]

I have a report that I have automated. While it's running, it's visibility property is set to false.

I have the Workbook save itself after it retrieves all the data and enters it in the correct cells/tabs.

When it is told to save itself (using the VBA functions), and the disk is full, it just sits there....even with DisplayAlerts set to true.

So, I want to be able to compare the current size of the workbook (it increases due to the data it gathers, or if it needs to add new tabs) to the disk space available to it.

I saw some recomendations on using FSO, but I would prefer to avoid that.

I also ran across 'BuiltinDocumentProperties', but unsure how to actually see the properties...I have received errors when trying to display them in a messagebox.

Any help would be appreciated! Thanks!!

[RobDog888]

There is a "Number of Bytes" property but its returning an error
for me. Maybe it can help you.

ActiveWorkbook.BuiltinDocumentProperties.Item ("Number of Bytes")

[jeffcravener]

...I am getting the errors as well...weird...

[RobDog888]

Try looping through the items collection checking the values for
each element.

[BrianB]

<<current size of the workbook >>

MySize = FileLen("C:\TEMP\MYFILE.XLS")

[jeffcravener]

that show the size of the workbook the last time it was saved?

[BrianB]

Yep. I don't think you can get a file size if it is not on disk.
Could try looking at the .tmp file size I suppose. Problem would be nowing the file name.