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
|