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

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

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

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

Thanks again. That link is an excellent resource.


"Jacob Skaria" wrote:

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