ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to trap the error message "Remote Data not accessible"? (https://www.excelbanter.com/excel-programming/287103-how-trap-error-message-remote-data-not-accessible.html)

rghpvf

How to trap the error message "Remote Data not accessible"?
 
I have tried to use IsError and On Error in VBA to trap the error
message "Remote Data not accessible" when a DDE program is not active,
but I keep getting the dialog box. I want to clear the active cell if
the program is not running. Any ideas?


---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 10:41 AM.

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