LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAP CAP is offline
external usenet poster
 
Posts: 1
Default email on condition from "import external data"


I am trying to get an excel worksheet to email me when a cell value
changes. I have been able to accomplish this if I manually change the
cell data or if it changes by formula.

My problem is, when the cell data changes by receiving new data from a
refresh of "import external data", the data change will not invoke my
send mail macro.

Any ideas?


--
CAP
------------------------------------------------------------------------
CAP's Profile: http://www.excelforum.com/member.php...o&userid=27720
View this thread: http://www.excelforum.com/showthread...hreadid=472351

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding to excel "table" using external data query Irvine, Dennis Excel Discussion (Misc queries) 0 February 15th 08 10:06 PM
Parameters In External ODBC Data Queries - "is one of" Michael R Excel Discussion (Misc queries) 0 October 2nd 07 10:52 AM
Excel Service error "cannot connect to external data source" Jooho Excel Discussion (Misc queries) 1 October 30th 06 11:08 PM
Remove "Refresh external data" from template Stéfan Robert Excel Programming 1 August 23rd 05 02:09 PM
excel: external data "data range properties" button dosent work HelpMuchNeeded Excel Programming 0 March 22nd 05 08:07 PM


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"