VBA Check whether file exists on Excel exit.

[drefiek2]

Good day,
I need a code which will check whether a particular file exists in a particular folder on Excel exit.
If the file exists it should just close Excel with no popup.
If the file does not exist it should popup with a message. I would like the popup to have a custom message and to have two buttons 'Go Back' or 'I am Viewing Only'. If the latter is clicked Excel should close, if the former is clicked the popup should close and Excel should remain open.
Thank you.

 

[Micron]

I would like the popup to have a custom message and to have two buttons 'Go Back' or 'I am Viewing Only'. If the latter is clicked Excel should close, if the former is clicked the popup should close and Excel should remain open.

a) I think you mean the workbook, not necessarily Excel? If you have 2 wb's open and you close one, Excel app is still running.
b) if by popup you mean a standard message box, you cannot have custom button captions and are limited to the built in choices. However, you can present a message that explains which button to click for a particular action.

A workbook has a close event that you can cancel in order to "go back". In that event you'd code to see if the file exists. Research "excel vba check if file exists" and you'll get over a million hits, many/most with code examples. Did you do that and try to cobble something together that works? You could just put the code example in your wb close event (without using the Sub, End Sub lines from the code example).