Error Handling - Check a file isn't already open before overwritin
 

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

Error Handling - Check a file isn't already open before overwritin
 

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

Error Handling - Check a file isn't already open before overwr
 

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

Error Handling - Check a file isn't already open before overwr
 

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

Error Handling - Check a file isn't already open before overwr
 

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