Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check for Open File! | Excel Discussion (Misc queries) | |||
Error Handling | Excel Discussion (Misc queries) | |||
EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
check if file is already open | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions |