On Error Goto linenumber
is used handle the error and go to a particular line..0 would mean not to
resume next or goto any other line but to the same line and return the
error...
You may go through the documentation
http://msdn.microsoft.com/en-us/libr...73(VS.60).aspx
If this post helps click Yes
---------------
Jacob Skaria
"NDBC" wrote:
Thanks Jacob. Took me a little while to sort out what a function was and how
they worked but I'm there now. One thing I don't understand is this statement
On Error GoTo 0 ' Turn error checking back on.
I know it says it turns error checking back on but what does goto 0 mean.
On another sidenote. In the process of putting explanations through my code
I realised that I was doing a few things the long winded way and have now
made things more efficient. Another benefit of going through the process.
Thanks for all your help.
"Jacob Skaria" wrote:
Check out
http://support.microsoft.com/default.aspx?kbid=138621
If this post helps click Yes
---------------
Jacob Skaria
"NDBC" wrote:
I have some code that exports data from my workbook to a new workbook. The
file name is the strFile variable and the file folder path is the strFolder
variable.
wbNew.SaveAs strFolder & strFile & ".xls"
wbNew.Close
I get an error if you are exporting data for a second time and have
forgotten to close down the exported file after viewing it.
Can I put in some sort of check that will show a message saying the file is
open, please close it and try again rather than it taking the user to the
debugger.
Thanks