OutputTo macro with MsgBox - Help!

[hermanko]

Hi,

I have a an action macro OutputTo that exports my queries into Excel. I
want to include a message box saying something like "Data exported
successfully" once it has been exported (clicked "OK" in the Output To
dialog box). However if the user clicks Cancel instead, the msg will
still display, even tho nothing has been exported.

There really isn't any code to work with since it's just an action
macro. How can i fix it so that i can display the msgbox only if OK is
clicked?

Thanks
Herman

 

[tina]

you can't do that in a macro, you'd have to use VBA code to control it
(probably do-able in VBA; i've personally never tried it).

hth