| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display MsbBox in Word using Excel VBA
Hi,
I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
You probably want the messagebox in the same Word instance which contains
the report, assuming that's why you're using Word. Earlier in the routine you probably have one of these: Set appWord = New Word.Application Set appWord = CreateObject("Word.Application") Set appWord = GetObject(, "Word.Application") and then you create the report within appWord. Don't kill appWord until after you've executed this line: appWord.MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
Hi Jon,
When I try to write appWord.* , I don't have MsgBox choice and it doesn't work if I write it ? appWord.Application.MsgBox doesn't work too. I seems that msgbox is in class interaction. Do you have an other idea? Thanks! Alex Set appWord = New Word.Application appWord.Visible = True Set MyDocWord = appWord.Documents.Add -- Alex St-Pierre "Jon Peltier" wrote: You probably want the messagebox in the same Word instance which contains the report, assuming that's why you're using Word. Earlier in the routine you probably have one of these: Set appWord = New Word.Application Set appWord = CreateObject("Word.Application") Set appWord = GetObject(, "Word.Application") and then you create the report within appWord. Don't kill appWord until after you've executed this line: appWord.MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
I searched the excel newsgroups for "msgbox word" and found this hit from
Orlando Magalhães Filho. http://groups.google.co.uk/group/mic...3dbe5d951282a6 or http://snipurl.com/1dfpi ======== Sub MsgBoxOverWord() Dim WordApp As Object Set WordApp = CreateObject("word.application") With WordApp .Visible = True .Documents.Add WordApp.WordBasic.MsgBox "Hi!", 1 .Quit End With End Sub Harald Staff added a link to show how to use an API call to put the message box atop any application. Alex St-Pierre wrote: Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
ps. That worked for me in xl2003.
Alex St-Pierre wrote: Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
You could either follow up on Dave's suggestions, or just use
MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi Jon, When I try to write appWord.* , I don't have MsgBox choice and it doesn't work if I write it ? appWord.Application.MsgBox doesn't work too. I seems that msgbox is in class interaction. Do you have an other idea? Thanks! Alex Set appWord = New Word.Application appWord.Visible = True Set MyDocWord = appWord.Documents.Add -- Alex St-Pierre "Jon Peltier" wrote: You probably want the messagebox in the same Word instance which contains the report, assuming that's why you're using Word. Earlier in the routine you probably have one of these: Set appWord = New Word.Application Set appWord = CreateObject("Word.Application") Set appWord = GetObject(, "Word.Application") and then you create the report within appWord. Don't kill appWord until after you've executed this line: appWord.MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display MsbBox in Word using Excel VBA
Thanks!!
Dave's suggesion is working good. Word 2002 recognize appWord.WordBasic.MsgBox "Hi!" -- Alex St-Pierre "Jon Peltier" wrote: You could either follow up on Dave's suggestions, or just use MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi Jon, When I try to write appWord.* , I don't have MsgBox choice and it doesn't work if I write it ? appWord.Application.MsgBox doesn't work too. I seems that msgbox is in class interaction. Do you have an other idea? Thanks! Alex Set appWord = New Word.Application appWord.Visible = True Set MyDocWord = appWord.Documents.Add -- Alex St-Pierre "Jon Peltier" wrote: You probably want the messagebox in the same Word instance which contains the report, assuming that's why you're using Word. Earlier in the routine you probably have one of these: Set appWord = New Word.Application Set appWord = CreateObject("Word.Application") Set appWord = GetObject(, "Word.Application") and then you create the report within appWord. Don't kill appWord until after you've executed this line: appWord.MsgBox "Report created", vbExclamation, "Message" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex St-Pierre" wrote in message ... Hi, I would like to make a popup (msgbox) in word using Excel VBA. Any idea ? something like.. Set appWord = New Word.Application appWord.MsbBox = "Report created" Thanks! Alex -- Alex St-Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display symbols in embedded excel sheet in word | Excel Discussion (Misc queries) | |||
| display list or word | Excel Discussion (Misc queries) | |||
| date display from excel in word | Excel Programming | |||
| Display Word Paragraphs in Excel??? | Excel Programming | |||
| msbbox | Excel Programming | |||
Linear Mode
