ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox in Access Automate Excel (https://www.excelbanter.com/excel-programming/336329-msgbox-access-automate-excel.html)

Picos Autom

MsgBox in Access Automate Excel
 
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 from another
application like Access?

--
Sincerilly, thanks a lot.

Oscar Picos
Office Autom


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com