N
NDBC
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
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