"Mohan Manicks" wrote in message
...
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 *