Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get file size
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get file size
"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 * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get file size
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 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) |