Message Box (on open) to choose (or not) to open a file

[sdoppke]

Hi everyone, a lot on this topic, but none that directly address my need, any help would really be appreciated

The title says it all. Im looking for a macro, that on open of the workbook, generates a pop-up (messagebox) that has a message and a choice to open or not a file, that will most likely not be located within the workbook itself.

Thanks in advance everyone

sd

 

[John Davis]

Hi everyone, a lot on this topic, but none that directly address my need, any help would really be appreciated

The title says it all. Im looking for a macro, that on open of the workbook, generates a pop-up (messagebox) that has a message and a choice to open or not a file, that will most likely not be located within the workbook itself.

Thanks in advance everyone

sd

Does this help?

http://msdn.microsoft.com/en-us/library/139z2azd(v=vs.80).aspx

You'd probably want to create a msgbox and place it in the Workbook open event (ThisWorkbook).