Opening A Workbook After Closing

  • Is it possible in vba to close the current workbook you are using without saving changes, re-open it, update a cell value, then close that workbook this time saving changes?

    I had code that worked, but when I tried it again in another workbook it would close the first time, terminating the code.

  • Re: Opening A Workbook After Closing

    You can do that from another workbook, not in code in a workbook that's closing itself.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!