LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default Newbie Q: Error handling procedures in a loop

Excellent, this is a much preferable solution (and bonus- easy enough for me
to understand :)

"Jim Thomlinson" wrote in message
...
Error handling should realy only be used to handle unaticipated events,

such
as the lack of a network connection, or something that will only happen

once
ina blue moon. If you can reasonaly expect something to happen then you

shoud
write your code to anticipate that event. (Error handling actually has a

lot
of overhead that will slow down your code). My recomendation for your
procedure would be to use the Dir function just ahead of the open.

if Dir(FileName & Path) = Filename then
'open the file and read from it... with your code
end if

HTH



 
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
VBA Newbie: Help with Do Loop code Carl Excel Discussion (Misc queries) 3 December 2nd 04 07:04 PM
VBA Newbie: Help with Do Loop code Carl[_5_] Excel Programming 3 December 2nd 04 07:04 PM
Handling Null Field in Macro Loop Ken Excel Programming 2 October 19th 04 10:17 PM
Loop macro for a Newbie mike Excel Programming 3 December 31st 03 06:35 PM
newbie: stop a FOR NEXT loop Mike H[_7_] Excel Programming 4 October 11th 03 04:47 PM


All times are GMT +1. The time now is 05:10 PM.

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"