Results 1 to 2 of 2

Thread: Check file size

  1. #1
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169

    Unanswered: Check file size

    Does anyone know how to get file information through VBA?

    I want to get the file size of something before i copy it to display a msg box that it may take a while to copy the file?

    Anyone know how?
    Based on DAO 3.6 and Access 2000 + 2003
    VB.Net 2005 + ADO.Net

  2. #2
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Sorry, im making a habit of this, ive sorted it.

    Solution as follows

    VB has a FileLen function

    Used as FileLen(FileName)

    Divide the answer of that by 1048576 to get the average mb of the file
    Based on DAO 3.6 and Access 2000 + 2003
    VB.Net 2005 + ADO.Net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •