Msg Box in Excel From Word

[yukimatsu]

Hello. I hope this is the right place for this question.

I have a Word macro that copies a table to a new Excel document.
That part is working fine. But once the item has been pasted, I want a message box to open IN EXCEL to tell the user what to do next.

So far, no matter what I do, the MsgBox only displays in Word, which is useless to me.

How can I specify that the MsgBox should be in EXCEL?

Code is below.

Please Login or Register  to view this content.

[pike]

Hi yukimatsu
If you have a module in the word Document with the messagebox sub
export and import the module to the excel workbook then run the sub

Please Login or Register  to view this content.