Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"On error....go to" staement is not working in my macro
thanks for all of u the macro now is working properly by putting reume next after err:. Also i changed the ActiveWorkbook.Close (False) to workbooks (file).colse (false) thx again- misho00
- Post #6
- Forum: Microsoft: Office
-
"On error....go to" staement is not working in my macro
Pls explaine where to put resume next in the macro, what i know that "resume next" is another kind of fo error... Anyway here is the macro itself, as I said it opens files in a range that defined by user... thx 4 helping Sub mmm() Application.ScreenUpdating = False Dim date1 As Date...- misho00
- Post #4
- Forum: Microsoft: Office
-
"On error....go to" staement is not working in my macro
*My macro is opening certain number of files according to user input to take some data and put them in a table. *I include "On error .... go to" statement in my macro to bypass the loop when some files are missed *The macro runs correctly when facing the first error it proberly...- misho00
- Thread
- Replies: 5
- Forum: Microsoft: Office
