Get file size

  • Thread starter Thread starter Mohan Manicks
  • Start date Start date
M

Mohan Manicks

Is there a way to get the file size (in KB) into
Excel sheet through VBA. I am already opening this text
file and copying the contents into the excel sheet through
VBA. I also want to get the file size & file name.
 
Mohan Manicks said:
Is there a way to get the file size (in KB) into
Excel sheet through VBA. I am already opening this text
file and copying the contents into the excel sheet through
VBA. I also want to get the file size & file name.
Click to expand...

Hi Mohan,

The FileLen function will return the size of the specified file in
bytes. You can get KB by dividing the number of bytes by 1024.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Back
Top