VBA partially run due to LAN disconnected during program runing RRS feed

  • Question

  • Hi all,

    I wrote some VBA codes in an excel workbook, and put this workbook in a shared folder, it works well. But recently the codes can only run partially due to the LAN disconnetted timely, and even worse, the whole workbook lost.

    Can anybody help to tell me how to fix this issue, such like make the codes wait untill the LAN re-connected, or put the data in a buffer somewhere?

    Thanks a lot!


    Thursday, December 5, 2013 5:51 AM