Displaying Msgbox in another application

[jrice174]

I'm writing a VBA program in AutoCAD. I open Excel and dump some data in the spreadsheet and then I want to display a msgbox that says "Data Extraction Completed". Since the spreadsheet is on top, I need to invoke the msgbox from the Excel application for it to be on top. Can I display a msgbox in Excel from AutoCAD?

 

[Beggar]

I don't think you can do it directly but you could have a macro inside of Excel that would display the message box when a certain cell is populated. Then, have the last step of your data dump be to write a flag to that cell.

--------------------
How much do YOU owe?

http://www.brillig.com/debt_clock/

--------------------

 

[handleman]

I don't know of a way, other than having the Excel sheet contain a macro and calling the macro using the .run method of the Excel Application object.


Would it suffice to re-activate AutoCad, display the message box, and then re-activate Excel?

Alternately, you could set the Excel application visibility to False while processing, and then set it to True and AppActivate it when processing is complete. Then the message box is not needed.

 

[jrice174]

That was too easy. It worked fine and it gave me the exact results I wanted. THANKS

 

[bpeirson]

What was easy, which method did you use?

 

[jrice174]

I opened the Excel spreadsheet and wrote the data to the spreadsheet. Then I used the command Excel.Visible = False to hide the spreadsheet so the AutoCAD application was visible to display the msgbox. After the msgbox statement I then had the Excel.Visible = True command to make the Excel application visible again. Just make sure that the last thing you do is make the spreadsheet visible or else when you go to open it again, you won't see anything.