I am creating a new workbook that would enable a user other than myself to open the workbook and a macro to receive info based on an automatic update. They will need to "reopen it" several times prior to being done for the day. I am using formulas to take out info particular accounts to provide a better information but they will not need to save it.
I am running into this error message
"Workbook.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen Workbook.xls?" with yes and no as options.
Is there a way that I can write VBA to say yes?
I am running into this error message
"Workbook.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen Workbook.xls?" with yes and no as options.
Is there a way that I can write VBA to say yes?