exit macro from VB ??

[steve]

Im a basic user of VB and Macros.

I have a simple little macro that imports some data.

The area that IM having problem with is I want to on a msgbox either
keep runing the macro or close it.

The reason why I dont want to use msgbox action in the macro builder or
the stopmacro action in the message builder with a msgbox as a
condition is because the message Im leaving is sort of big. Its just
easier for me to write in a vb window.

So what I want to do is run a macro

have it run code
MsgBox("A new loginfo.log will be imported. yadda yaddia Do you want to
STOP!!", vbOKCancel) = vbCancel)
then based on this info either keep going or stop the originating
macro.

Can you do this ??
If so can you show me the code how to do this?

thank you.

 

[Guest]

Hi Steve,

It seems to me that the easiest solution would be to convert your working
macro to VBA code, and then incorporate it into your existing code. See this
posting for an example of responding to VbYes:

http://www.microsoft.com/office/com...ovba&mid=ca8d3d7d-d8c2-47f6-8ad3-a4248c58a8f0


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[steve]

Thanks.