Max Alejandro Molina
Member
Hello Excel Ninjas,
Everyonce I week a Macro to extract the info from a text file, format it and paste into my excel workbook, but sometimes the text file is not updated or the file is being exported and it weighs 0kb at the moment, I wanna know if I can prove that the .txt file weighs more than 0kb and then If wheter the .txt. file is from today().
*If the macro detects the .txt file weighs 0kb or is <> from today() then i want a message box that says "Keep in mind that this info will be missing", and then it continues with the other 2 .txt files..
Attached you will find the Macro I use..
Thank you all!
Everyonce I week a Macro to extract the info from a text file, format it and paste into my excel workbook, but sometimes the text file is not updated or the file is being exported and it weighs 0kb at the moment, I wanna know if I can prove that the .txt file weighs more than 0kb and then If wheter the .txt. file is from today().
*If the macro detects the .txt file weighs 0kb or is <> from today() then i want a message box that says "Keep in mind that this info will be missing", and then it continues with the other 2 .txt files..
Attached you will find the Macro I use..
Thank you all!