Search results for query: *

Hi, Well, the code would not apply to anyone's case. Just the notion of moving the Close block down through the code to inspect the Close/Doesn't Close nature of the Excel objects. Thanks

I was trying to close Excel from VB 6, or VBA and reopen the same workbook when the routine was run again. This was made impossible as the Excel process would stay alive (observed on the Task Manager) no matter how much closing I did. After trying all the possible answers (thanks, guys!) I had...

Thanks, but the link is to a table in Access that gets re-queried by yet another piece of VB. The vb then opens the Excel where the data is to be viewed in the spreadsheet. Having asked the question and made other clarifications, it occurred to me to try another thing. Because I am now (since...

Thanks. This was the first thing to try. Does nothing. Sorry I left it out of the example. It looks like the action of the file opening is adding its own layer of checking and testing. I cannot trap the line of code since it only happens differently at Open and the breakpoints don't stay after...

Nice to belong to such a group. I have been scanning your pages for a long time now. I have an Excel workbook that is linked to an Access table. The table link is set to refresh when the workbook opens. This works fine once I used...