View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Matrix[_2_] Matrix[_2_] is offline
external usenet poster
 
Posts: 4
Default Export values in a text file

On Sun, 2 Nov 2003 08:27:45 -0500, "jaf" wrote:

Hi,
Target.Value would be the contents of D9.
For the event to evaluate to true and run Mytexfile you have to give it the
cell address so it knows which cell is the current cell.
This way you can evaluate more than one cell.



Ok, now it works, but there is a big problem
Change Event doesn't work with DDE link:
http://support.microsoft.com/?kbid=172832

The right solution is SetLinkOnData, but i haven't understood how it
works.

Please Jaf can you tell me how i can adapt previous vba code with
SetLinkOnData?

Thanks a lot