LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting text from external file into cells. warirv63 Excel Discussion (Misc queries) 0 April 16th 08 07:27 AM
Update Columns based on External Text file iMacFlats Excel Programming 1 June 9th 05 10:20 PM
appending data from an external text file clui[_7_] Excel Programming 1 December 4th 03 01:21 AM
How do I send some cells to an external text file? lothario[_2_] Excel Programming 1 October 12th 03 02:34 PM
Get External Data, Import Text File, File name problem Scott Riddle Excel Programming 1 July 11th 03 05:40 PM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"