View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LL Cool A LL Cool A is offline
external usenet poster
 
Posts: 2
Default How to check if external .txt file has text in it...

Hi everyone,

I've recorded a macro that imports a .txt file generated from other
software. The .txt file that the other software generates sometimes has text
in it and sometimes doesn't have text in it, updated about every 10 secs. The
problem is that when the external .txt file is completely empty, my macro
chrashes. I need help on writing code that will check if the external .txt
file has text in it. If so, the macro will keep running. Otherwise, it will
then wait some period of time. Any help would be greatly appreciated. Thanks.