Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) | |||
VBA Newbie: Help with Do Loop code | Excel Programming | |||
Handling Null Field in Macro Loop | Excel Programming | |||
Loop macro for a Newbie | Excel Programming | |||
newbie: stop a FOR NEXT loop | Excel Programming |