Re: Workbook size?

Thanks guys :-)

Problem with the method is that it requires the wookbook to be saved!

What I was looking for was a way to determine the size of the workbook AFTER
changes has been made to it, but BEFORE saving it???

Anyway to do that?



"Mike H" <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i en meddelelse
news:C802A13F-8B0F-492E-A13D-44A824A40064@xxxxxxxxxxxxxxxx
Charlotte,

Try

MyFileSize = FileLen(ThisWorkbook.FullName)

which returns the size in bytes

Mike

"Charlotte E." wrote:

When you right-click a workbook in windows, and select 'Properties' you
can
see the size of the workbook in bytes.

Is it possible to get a workbooks size from within the workbook by VBA
code?


TIA,






.

Relevant Pages

  • Re: Do not Update On Open
    ... The Manual option is not highlighted. ... Can I use a wookbook eventto say no to the prompt. ... Save it as a new workbook but keep it open. ...
    (microsoft.public.excel.programming)
  • Re: Using Vlookup to pull data from another workbook
    ... > Wookbook 1 ... > That value is then Looked up in the Table Array located in ... > When a match is located from Workbook 2, the value in column C is then ... > If B22 contains WHAPPA ...
    (microsoft.public.excel.programming)
  • Automatic Data Update
    ... How can i use macro to insert data from one workbook to another wookbook on a ... particular columns without affecting other columns. ...
    (microsoft.public.excel.programming)
  • Automatic Data Insertion Between Workbooks
    ... How can i use macro to insert data from one workbook to another wookbook on a ... particular columns without affecting other columns. ...
    (microsoft.public.access.macros)
  • Workbook Formats?
    ... I have a large wookbook with many worksheets. ... use that would auto fit all the columns in the entire workbook? ...
    (microsoft.public.excel.programming)