how msgbox from Word when ran from Excel?
 

Orlando Magalhães Filho gave a nice answer to your first post:

http://google.com/groups?threadm=008...0a% 40phx.gbl

And if you're looking for old posts:

you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

Ian Elliott wrote:

Thanks in advance.
I am writing a macro that gets some numbers from a Word
document and puts them in a worksheet.
I am trying to make some code so that if the number is not
found, the user is alerted, and instructed to highlight
the number the user wants brought it (by highlighting with
the mouse & mouse button).
I want to do a msgbox to alert the user, but when I do:

Dim wordapp as New Word.Application'ToolReferencesMS
' Word 10.0 Object Library
With wordapp
.Documents.Open filename:="Book1.xls"
...
msgbox "Hello world"
...
.Documents.Close
End With

When the msgbox is executed, the Word window closes and
goes to an icon on the bottom of the screen, and the
msgbox opens (with 'Excel' in its title), and since I ran
the macro with Excel open, Excel is on the screen. I would
like the msgbox to open above the Word document, is this
possible?
I tried
With wordapp
.msgbox "hello world"
End With
but that didn't work.

Thanks again.

--

Dave Peterson