Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Excel msgbox when cell range is clicked | Excel Discussion (Misc queries) | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
code to close an excel sheet without saving it .(via msgbox) | Excel Worksheet Functions | |||
Pop up MsgBox upon opening Excel File | Excel Discussion (Misc queries) |