Get file size

[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.

 

[Rob Bovey]

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.

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 *

 

[Robin Hammond]

Mohan,

not sure what you are doing in terms of opening a text file, but this will
return the size of an open workbook.

msgbox filelen(activeworkbook.fullname)

Robin Hammond
www.enhanceddatasystems.com