Msgbox in Excel from Access (Correct)
 

How can I show a Msgbox in EXCEL from VBA code in Access?

Note: Inputbox no problem.

--
Sincerilly, thanks a lot.

Oscar Picos
Office Autom

Msgbox in Excel from Access (Correct)
 

Oscar,

It is difficult to imagine what problem you are having with a MsgBox if
Inputbox is good.

It should just be something like

ans = MsgBox("testing",vbYesNo)

Is your code being run in Access, or is it in Excel?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Picos Autom" wrote in message
...
How can I show a Msgbox in EXCEL from VBA code in Access?

Note: Inputbox no problem.

--
Sincerilly, thanks a lot.

Oscar Picos
Office Autom

Msgbox in Excel from Access (Correct)
 

Bob:

Sorry for my weak explication (and my english too), my problem is:

A procedure in Access automate an instance of Excel with this code:

Set xlApp = New Excel.Application
xlApp.Visible = True
xlApp.Workbooks.Open "C:\Trial.xls"
xlapp.InputBox "Hello" 'This work but doesn't the
right solution.
xlApp.MsgBox "Hello" 'This not work, and is the
right solution.

Now, How can I show that message in Excel, with code form another
application like Access?
--
Sincerilly, thanks a lot.

Oscar Picos
Office Autom


"Bob Phillips" wrote:

Oscar,

It is difficult to imagine what problem you are having with a MsgBox if
Inputbox is good.

It should just be something like

ans = MsgBox("testing",vbYesNo)

Is your code being run in Access, or is it in Excel?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Picos Autom" wrote in message
...
How can I show a Msgbox in EXCEL from VBA code in Access?

Note: Inputbox no problem.

--
Sincerilly, thanks a lot.

Oscar Picos
Office Autom